dataadapter的更新数据库问题

[wicked]

Dim cnnstr As String
cnnstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("mydb.mdb") & ";"
Dim MyOleDbConnection As New System.Data.OleDb.OleDbConnection(cnnstr)
MyOleDbConnection.Open()

Dim sqlstr As String = "select * from test"
Dim MyOleDbCommand As New System.Data.OleDb.OleDbCommand(sqlstr, MyOleDbConnection)
Dim MyOleDbDataAdapter As New System.Data.OleDb.OleDbDataAdapter()
MyOleDbDataAdapter.SelectCommand = MyOleDbCommand

Dim MyDS As New System.Data.DataSet()
Dim dt As System.Data.DataTable
dt = MyDS.Tables.Add("aaa")
MyOleDbDataAdapter.Fill(dt)

Dim dr As System.Data.DataRow
dr = dt.NewRow
dr("id") = CType("6", System.Int32)
dr("name") = CType("hello", System.String)
dt.Rows.Add(dr)

dt.AcceptChanges()
MyOleDbDataAdapter.Update(dt)

DataGrid1.DataSource = dt
DataGrid1.DataBind()

MyOleDbConnection.Close()
但是我的数据表却没有更新！！！难道MyOleDbDataAdapter.Update(dt)语句有问题吗？请指教！！！谢

[showflow]

dt.AcceptChanges()
放在
MyOleDbDataAdapter.Update(dt)之后

[wicked]

对的，但是我不明白为什么这样，按照逻辑，应该是先更新dt，再更新数据库啊，能给小弟解释一下吗？另外，我想修改和删除数据也能这样做吗？谢了！

[happypolo]

oledbdataadapter.update(dataset);更新数据表必须要求数据表中的行都正确....