You need to call the EndEdit method of the DataRow before you try and Update. This flags to the ADO.NET that you are finished editing the current row.

>I created a typed dataset which consist of 4 related tables. I noticed that after running an update command, changes made are not saved to SQL until I move the record pointer of the dataset to another record and then run the update command.
>WHY?