62,046
社区成员
发帖
与我相关
我的任务
分享
SqlConnection pConn = new SqlConnection(connString);
SqlTransaction pTrans = null;
try
{
pConn.Open();
pTrans = pConn.BeginTransaction();
using (SqlBulkCopy bcp = new SqlBulkCopy(pConn, SqlBulkCopyOptions.FireTriggers, pTrans))
{
bcp.DestinationTableName = "temp_" + tableName;
bcp.WriteToServer(data);
}
// 提交事务
pTrans.Commit();
pConn.Close();
}
catch (Exception ex)
{
pTrans.Rollback();
}