using System.Data.SqlClient;
using System.Configuration;
//目标表
string TableName = "taskissued_dxly";
//连接字符串
string conStr = ConfigurationManager.ConnectionStrings["SqlConnection"].ToString();
using (SqlConnection conn = new SqlConnection(conStr))
{
using (SqlBulkCopy sqlbulkcopy = new SqlBulkCopy(conStr, SqlBulkCopyOptions.UseInternalTransaction))
{
try
{
sqlbulkcopy.DestinationTableName = TableName;
for (int i = 0; i < dt.Columns.Count; i++)
{
sqlbulkcopy.ColumnMappings.Add(dt.Columns[i].ColumnName, dt.Columns[i].ColumnName);
}
sqlbulkcopy.WriteToServer(dt);
}
catch (System.Exception ex)
{
throw ex;
}
}
}