向数据库中批量插入数据

 1 /// <summary>
 2 /// 往数据库中批量插入数据
 3 /// </summary>
 4 /// <param name="sourceDt">数据源表</param>
 5 /// <param name="targetTable">服务器上目标表</param>
 6 public static void BulkToDB(DataTable sourceDt, string targetTable)
 7 {
 8 SqlConnection conn = new SqlConnection(strConn);
 9 SqlBulkCopy bulkCopy = new SqlBulkCopy(conn); //用其它源的数据有效批量加载sql server表中
10 bulkCopy.DestinationTableName = targetTable; //服务器上目标表的名称
11 bulkCopy.BatchSize = sourceDt.Rows.Count; //每一批次中的行数
12 
13 try
14 {
15 conn.Open();
16 if (sourceDt != null && sourceDt.Rows.Count != 0)
17 bulkCopy.WriteToServer(sourceDt); //将提供的数据源中的所有行复制到目标表中
18 }
19 catch (Exception ex)
20 {
21 throw ex;
22 }
23 finally
24 {
25 conn.Close();
26 if (bulkCopy != null)
27 bulkCopy.Close();
28 }
29 
30 }

喜欢我的博客请关注哦！