关于OleDbDataAdapter.update

[BloodPhenix]

        MyODA.SelectCommand = New OleDb.OleDbCommand(Sql, Conn)
        cmdBuilder = New OleDb.OleDbCommandBuilder(MyODA)
        MyODA.InsertCommand = cmdBuilder.GetInsertCommand()
        MyODA.DeleteCommand = cmdBuilder.GetDeleteCommand()
        MyODA.UpdateCommand = cmdBuilder.GetUpdateCommand()
        MyODA.Fill(MyDs)
'---------更新子过程---------------------------------
        myDataView.DataSource = MyDs.Tables(0)
        If MyDs.HasChanges Then
            MyODA.Update(MyDs.Tables(0))
        End If

---------------------------------------------------------
以上代码,每当我在girdview里面用代码更改某单元格值时, 如果更新多条记录就能正常更新到数据库
要是代码只改了一条记录的话,就不能更新到数据库,请问有人碰到过这样的情况吗?怎么解决的?

[机器人]

修改单元格的值的代码贴出来看看。

[Yangbin990]

Maybe need to change mouse cursor to next record
Because if you don't move mouse to next record, the record state would be changed to "modified".
So adpater is not awared that the record has been modifed.

[sjm2003]

俺不是用你这方法做的,不是自动获取SQL语句
用的是DATASET,程序似乎没你这毛病