dim tran as SqlTransaction = null ‘声明一个事务对象
try
dim conn as SqlConnection = new SqlConnection("server=.;uid=sa;pwd=sa;database=Test;"))
conn.Open() '打开链接
tran = conn.BeginTransaction()
dim copy as SqlBulkCopy = new SqlBulkCopy(conn, SqlBulkCopyOptions.Default, tran))
copy.Destinati '指定服务器上目标表的名称
copy.WriteToServer(MyDataTable) '你的datatable名字,执行把DataTable中的数据写入DB
tran.Commit() '提交事务
catch (Exception ex)
tran.Rollback() '返回False 执行失败!
end try
这段代码如何改成FT的事务处理了