数据库批量插入数据SqlBulkCopy 

 1             string connstr = ConfigurationManager.ConnectionStrings["connstr"].ConnectionString;
 2             DataTable dt = new DataTable();
 3             dt.Columns.Add("Sname");
 4             dt.Columns.Add("SAge");
 5 
 6             for (int i = 0; i < 80000;i++ )
 7             {
 8                 DataRow row = dt.NewRow();
 9                 row["Sname"] = "aa" + i;
10                 row["Sage"] = i * i;
11                 dt.Rows.Add(row);            
12             }
13 
14 
15             using (SqlBulkCopy bulkCopy = new SqlBulkCopy(connstr))
16             {
17                 bulkCopy.DestinationTableName = "student";
18                 bulkCopy.ColumnMappings.Add("Sname", "Sname");
19                 bulkCopy.ColumnMappings.Add("Sage", "Sage");
20                 bulkCopy.WriteToServer(dt);
21             }

 

posted @ 2016-10-24 15:28  墨水心2016  阅读(143)  评论(0)    收藏  举报