Update record - what is wrong?

[Kid_Icarus]

Im trying to update my table in the database, using this code;

 

        ÄrendeBindingSource.EndEdit()
       ITMDBDataSet.Ärende.AcceptChanges()
       ÄrendeTableAdapter.Update(ITMDBDataSet.Ärende)

 

What am I doing wrong?

 

And also, what is the command to delete a record?

 

Simple questions I know...

 

 

Kind regards,

Kid Icarus

[PlausiblyDamp]

Don't 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 doesn't see any rows has having changes.

[Kid_Icarus]

Don't 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 doesn't see any rows has having changes.

 

 

I get this message when I dont have acceptchanges:

 

Update requires a valid UpdateCommand when passed DataRow collection with modified rows.

 

??

 

Kid Icarus.

[PlausiblyDamp]

Have you assigned a valid command to the DataAdapter's .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.