- protected void Button1_Click(object sender, EventArgs e)
- {
- try
- {
- string cs = ConfigurationManager.ConnectionStrings["SchoolConnectionString"].ConnectionString;
- using (SqlConnection sqlConn = new SqlConnection(cs))
- {
- DataSet ds = new DataSet();
- ds.ReadXml(Server.MapPath("~/Data.xml"));
- DataTable dtStudentMaster = ds.Tables["Student"];
- sqlConn.Open();
- using (SqlBulkCopy sqlbc = new SqlBulkCopy(sqlConn))
- {
- sqlbc.DestinationTableName = "StudentMaster";
- sqlbc.ColumnMappings.Add("Name", "Name");
- sqlbc.ColumnMappings.Add("Phone", "Phone");
- sqlbc.ColumnMappings.Add("Address", "Address");
- sqlbc.ColumnMappings.Add("Class", "Class");
- sqlbc.WriteToServer(dtStudentMaster);
- Response.Write("Bulk data stored successfully");
- }
- }
- }
- catch (Exception ex)
- {
- throw ex;
- }
- }
Sunday, June 16, 2019
SQLBulkCopy in C#
Subscribe to:
Post Comments (Atom)
javascript Filter/index off
var family = [{"name":"Jack", "age": 26}, {"name":"Jill", "age"...
-
A3+C3 VLOOKUP(G3,$A$3:$B$10,2) sum Product Quantity Count Result 1 Mobile 2 1 Mobile 3 Keyboard 3 2 Mobile 6 TV 1 3 ...
-
EF CORE CLI > dotnet ef database update MyFirstMigration. Scaffold-DbContext Command Use Scaffold-DbContext to create a model based ...
No comments:
Post a Comment