c#中对批量新增数据中使用SqlBulkCopy

最新推荐文章于 2023-09-12 11:41:23 发布

weixin_30701575

最新推荐文章于 2023-09-12 11:41:23 发布

阅读量92

点赞数

原文链接：http://www.cnblogs.com/moondd22/p/9212368.html

版权

private void AddBulkInsert(string tableName, DataTable dt)
{
string connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["XzyConnstring"].ToString();

using (SqlConnection destinationConnection =
new SqlConnection(connectionString))
{
destinationConnection.Open();
using (SqlBulkCopy bulkCopy =
new SqlBulkCopy(destinationConnection))
{
bulkCopy.DestinationTableName = tableName;

try
{
for (int i = 0; i < dt.Columns.Count; i++)
{
bulkCopy.ColumnMappings.Add(dt.Columns[i].ColumnName, dt.Columns[i].ColumnName);
}

bulkCopy.WriteToServer(dt);
}
catch (Exception ex)
{
return;
}
}
}
}

转载于:https://www.cnblogs.com/moondd22/p/9212368.html