关于如何将从二个表中取出的数据经修改后如何保存到各自表中???

[wsxwsx123456789]

关于如何将从二个表中取出的数据经修改后如何保存到各自表中???

'下面语句从二个表中取得数据
Dim myquery As String = " select A.ID 序号, A.F_Plucode as 书号,B.TITLE as 书名,c.name as 版别,b.price as 定价,a.f_disc as 结算折扣 from SettlementVarietyData a,PLU B,company c WHERE A.F_Plucode=B.PLUCODE AND B.PUBLISHER=C.CODE ORDER BY convert(int,A.ID) desc , A.F_Plucode "

Dim myconnection As New SqlConnection(SqlConnection_TOPS)
Dim mycommand As New SqlCommand
Dim mydataadapt As New SqlDataAdapter(myquery, myconnection)
Dim myCommandBuilder As New SqlCommandBuilder(mydataadapt)

Dim mytable As New DataTable
Dim MyDataSet As New DataSet

mycommand.Connection = myconnection
mydataadapt.SelectCommand = mycommand

mycommand.CommandText = myquery
mydataadapt.SelectCommand = mycommand

mytable.Clear()
Me.DataGridView3.DataSource = ""
mydataadapt.Fill(mytable)
mydataadapt.Fill(MyDataSet)
Me.DataGridView3.DataSource = mytable
Me.DataGridView3.Refresh()
'修改了DataGridView3的部分数据
..........................
'下面保存数据到二个表之中的一个
mydataadapt.Update(MyDataSet) '报错,这儿该如何写,
'问题就在上面这句话中,如何写上面的语句

'......................
myconnection.Dispose()
mydataadapt.Dispose()
Me.Close()
Me.Dispose()
Me.Finalize()

[wsxwsx123456789]

mydataadapt.Update(MyDataSet) '报错,这儿该如何写,
.........如何写到相应表中???是用table 还是用dataset

[zhangxuyu1118]

起用事务。
BeiginTran;
修改表1；
修改表2；
if 有错误
RollbackTran;
else
CommitTran;

[wsxwsx123456789]

修改表1;
修改表2;
用什么语句来写???如何写

[wsxwsx123456789]

[Quote=引用 2 楼 zhangxuyu1118 的回复:]
起用事务。
BeiginTran;
修改表1； '如何写语名?????
修改表2；
if 有错误
RollbackTran;
else
CommitTran;
[/Quote]

修改表1； '如何写语名?????
修改表2； '如何写语名?????