111,092
社区成员




/// <summary>
/// 执行批量插入数据
/// </summary>
/// <param name="table"></param>
/// <param name="sourceTableName">数据库源表名</param>
public void ExecuteInsert(DataTable table, string sourceTableName)
{
using (SqlBulkCopy bulkCopy = new SqlBulkCopy(strConn))
{
bulkCopy.DestinationTableName = sourceTableName;
if (table != null && table.Rows.Count != 0)
{
bulkCopy.WriteToServer(table);
}
}
}