批量插入数据

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24

public static void BulkToDB(DataTable dt, string tableName)         {             string connstring = DBUtility.PubConst.GetBusinessDbconnectionString();             SqlConnection sqlConn = new SqlConnection(connstring);             SqlBulkCopy bulkCopy = new SqlBulkCopy(sqlConn);             bulkCopy.DestinationTableName = tableName;             bulkCopy.BatchSize = dt.Rows.Count;             try             {                 sqlConn.Open();                 if (dt != null && dt.Rows.Count != 0)                     bulkCopy.WriteToServer(dt);             }             catch (Exception ex)             {                 throw ex;             }             finally             {                 sqlConn.Close();                 if (bulkCopy != null)                     bulkCopy.Close();             }         }