一个事务处理的问题，帮忙解答一下，谢谢
public string UpdateOrderStatus(DataTable dt)
{

SqlConnection myconn = GetConn();


SqlCommand Cmd = new SqlCommand();
Cmd.Connection = myconn;
Cmd.CommandText = "select rowid into #tmpdata from deliverydata where 2=1";
Cmd.ExecuteNonQuery();


SqlTransaction sqlbulkTransaction = myconn.BeginTransaction();
SqlBulkCopy copy = new SqlBulkCopy(myconn, SqlBulkCopyOptions.CheckConstraints, sqlbulkTransaction);
copy.DestinationTableName = "#tmpdata";
foreach (DataColumn dc in dt.Columns)
{
copy.ColumnMappings.Add(dc.ColumnName, dc.ColumnName);
}
try
{
copy.WriteToServer(dt);
sqlbulkTransaction.Commit();

Cmd.CommandText = "insert into tracedata(rowid,inserttime,status) (select rowid,'" + DateTime.Now.ToString() + "','出仓扫描' from #tmpdata)";
Cmd.ExecuteNonQuery();


}
catch (Exception ex) {
sqlbulkTransaction.Rollback();
return(ex.ToString());
}
finally {
copy.Close();
myconn.Close();
}
return "完成";
}


我要把事务处理跟上面红色这段代码关联，请问如何修改？因为上述的事务处理只应用于SqlBulkCopy，但是没有应用于Cmd.CommandText = "insert into tracedata。。。这段代码，请问应该如何修改？

[解决办法]
Cmd.Transaction = sqlbulkTransaction;
Cmd.CommandText = "insert into tracedata(rowid,inserttime,status) (select rowid,'" + DateTime.Now.ToString() + "','出仓扫描' from #tmpdata)";
Cmd.ExecuteNonQuery();
[解决办法]
在红色语句前加入
Cmd.Transaction = sqlbulkTransaction;

将sqlbulkTransaction.Commit();放到红色后面