-
Database update
I am currently working with an access database using odbc. I am trying to update a database using a modified dataset. I cannot seem to get the update to work. Here is my current code.
DsMsg.Message.Rows(i).BeginEdit()
'Items in datarow I need to change
DsMsg.Message.Rows(i).Item("Checked") = "True"
DsMsg.Message.Rows(i).Item("Body") = "Changed"
DsMsg.Message.AcceptChanges()
DsMsg.Message.Rows(i).EndEdit()
odbcMessage.Update(DsMsg)
The values in the dataset get changed, but the database does not get updated. Any suggestions welcomed.