Kid_Icarus
Member
- Joined
- Dec 3, 2003
- Messages
- 9
Im trying to update my table in the database, using this code;
Code:
Update record - what is wrong?
- Thread starter Kid_Icarus
- Start date
PlausiblyDamp
Administrator
Dont call .AcceptChanges until after you have done the .Update().
AcceptChanges resets the RowState of all rows in the DataSet / DataTable, so when the .Update is called it doesnt see any rows has having changes.
AcceptChanges resets the RowState of all rows in the DataSet / DataTable, so when the .Update is called it doesnt see any rows has having changes.
Kid_Icarus
Member
- Joined
- Dec 3, 2003
- Messages
- 9
PlausiblyDamp said:
I get this message when I dont have acceptchanges:
Update requires a valid UpdateCommand when passed DataRow collection with modified rows.
??
Kid Icarus.
PlausiblyDamp
Administrator
Have you assigned a valid command to the DataAdapters .UpdateCommand property? If not then the Adapter has no way of knowing how to send the updates back to the data source.
Either write a valid update command (prefered way) or try to see if the CommandBuilder class can do it for you.
Either write a valid update command (prefered way) or try to see if the CommandBuilder class can do it for you.