110,533
社区成员
发帖
与我相关
我的任务
分享
//insert 整个表
public void BulkInsert(DataTable fromTable,string toTable_Name)
{
using (SqlBulkCopy copy=new SqlBulkCopy(this.DBConnection))
{
foreach (DataColumn col in fromTable.Columns)
{
copy.ColumnMappings.Add(col.ColumnName, col.ColumnName);
}
if (string.IsNullOrEmpty(fromTable.TableName))
copy.DestinationTableName = fromTable.TableName;
else
copy.DestinationTableName = toTable_Name;
copy.WriteToServer(fromTable);
}
}
//insert 多行记录
public void BulkInsert(DataRow[] Rows, string toTable_Name)
{
using (SqlBulkCopy copy = new SqlBulkCopy(this.DBConnection))
{
foreach (DataColumn col in Rows[0].Table.Columns)
{
copy.ColumnMappings.Add(col.ColumnName, col.ColumnName);
}
copy.DestinationTableName = toTable_Name;
copy.WriteToServer(Rows);
}
}