数据更新的问题。在线等

[prok]

我想修改表里的某一个值，在dataset里修改成功了。可是更新数据库时报错。“并发错误”高手指点多谢了！代码：
Dim cn As New OleDbConnection()
dim sql as string="select * form abc"

cn.ConnectionString = "provider= microsoft.jet.oledb.4.0;data source=e:\db1.mdb"

Dim cmd As New OleDbCommand(sql, cn)

cn.Open()
Dim dr As New OleDbDataAdapter(sql, cn)
Dim cmdup As New OleDbCommandBuilder(dr)
Dim rs As New DataSet()
dr.Fill(rs, "1")

rs.Tables("1").Rows(2).Item(0) = "aaa"
dr.UpdateCommand = cmdup.GetUpdateCommand
f1.ComboBox1.Items.Add(rs.Tables("1").Rows(2).Item(0))
dr.Update(rs, "1")

cn.Close()

[saucer]

after the update, call AcceptChanges on the DataSet

dr.Update(rs, "1")
rs.AcceptChanges()

[prok]

还是不行啊，报错修改失败，同步错误。能不能给个正确的更新数据库的例子？多谢了。高手大哥们

[lzg530]

up