vb.net 事务处理问题(Adapter.Update()和Sql语句组成的事务问题)
rmini 2017-04-08 12:55:02 之前已发过类似的,可能意思不太明确,现在重新求助一次:
Dim MyTransConn As SqlConnection = New SqlConnection("Data Source=(local);Initial Catalog=MyDoors;Integrated
Security=true;User ID=sa;Password=''")
MyTransConn.Open() '事务管理
Dim myTrans As SqlTransaction = MyTransConn.BeginTransaction()
'Dim command As SqlCommand = MyTransConn.CreateCommand()
Dim myCommand As SqlCommand = New SqlCommand()
myCommand.Connection = MyTransConn
myCommand.Transaction = myTrans
TRY
myCommand.CommandText = "insert into Order_Header ......" '操作一
myCommand.ExecuteNonQuery()
Dim table As DataTable = custds.Tables("Order_Detail")
Dim UserSqlstr As String = "SELECT.... FROM Order_Detail"
sqldataadapter1 = New SqlDataAdapter(UserSqlstr, MyTransConn)
Dim builder As SqlCommandBuilder = New SqlCommandBuilder(sqldataadapter1)
builder.QuotePrefix = "["
builder.QuoteSuffix = "]"
MyDataAdpter.Update(table) '操作二
myTrans.Commit()
MsgBox("数据保存成功!", 64, "提示")
Catch
MsgBox("错误号:" & Err.Number & "错误描述:" & Err.Description)
myTrans.Rollback()
End Try
vs2010 vb.net ,这个事务该怎么加或怎么修改?主要涉及两个表的操作,比如录入库单的时候,保存供应商的信息相当于操作一,保存供应商的材料明细相当于操作二(保存DEV的gridcontrol的gridview),这两个操作怎么组成一个事务?