using (SqlConnection ss = new SqlConnection(conn))
{
ss.Open();
using (var sqltr = ss.BeginTransaction()) //加入事務
{
using (SqlBulkCopy SBC = new SqlBulkCopy(conn, SqlBulkCopyOptions.Default))//, sqltr
{
SBC.DestinationTableName = "目标表表名";
SBC.WriteToServer("來源表"); //DataTable 對象
sqltr.Commit(); //送出 事務
}
}
}