/// <summary>
/// 使用SqlBulkCopy方式批量插入数据
/// </summary>
/// <param name="dt">数据源</param>
/// <param name="tableName">需要插入数据的表名</param>
/// <returns></returns>
public static void SqlBulkCopyInsert(DataTable dt, string tableName)
{
SqlBulkCopy sqlBulkCopy = new SqlBulkCopy(connectionString);
sqlBulkCopy.DestinationTableName = tableName;
//设置数据对应关系
foreach (DataColumn dc in dt.Columns)
{
sqlBulkCopy.ColumnMappings.Add(dc.ColumnName, dc.ColumnName);
}
sqlBulkCopy.BatchSize = dt.Rows.Count;
SqlConnection sqlConnection = new SqlConnection(connectionString);
sqlConnection.Open();
if (dt != null && dt.Rows.Count != 0)
{
sqlBulkCopy.WriteToServer(dt);
}
sqlBulkCopy.Close();
sqlConnection.Close();

}