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

时间:2018-06-22 11:44:53   收藏:0   阅读:195

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

评论(0
© 2014 bubuko.com 版权所有 - 联系我们:wmxa8@hotmail.com
打开技术之扣,分享程序人生!