C# · December 21, 2011

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

This is one of those frustrating errors that one encounters when using Typed dataset and trying to update a table in the dataset that doesnot contain a primary key.

dataset correction

To correct the error, just delete the table that generates the error from the dataset, from the server explorer, edit the table and give it a primary key, then re-drag it on the dataset and you are
good to go.

dataset correction