[.NET Error] Update requires a valid UpdateCommand when passed DataRow collection with modified rows

[.NET Error] Update requires a valid UpdateCommand when passed DataRow collection with modified rows

This is an error, with which i was dumbfounded for weeks. But the solution is simple after understanding why it's happening
Software Development
Like
by Jey Geethan | March 06, 2008

This is an error, with which i was dumbfounded for weeks. The problem is simple. I have a DataSet and it automatically generates INSERT command. So i can add rows to the DataSet and update it easily. But whenever i change values in existing rows and update it via TableAdapter, I get this exception "Update requires a valid UpdateCommand when passed DataRow collection with modified rows". I found inside the generated code that only INSERT command is generated. Whatever i try, the DataSet designer would not create an UPDATE command nor a DELETE command for this TableAdapter.

Solution 1:

You can select the TableAdapter and write your own query for the update command in the property dialog box.

But this is not a good idea.

Solution 2: (Better one)

The problem lies within your table design. Check it out again and check whether you have created a primary key for the table. Mostly this will be the case, as I forgot to create one. Now after creating the primary key, you can recreate the DataSets to get the corresponding UPDATE and DELETE statements.

But if you do not want a primary key in your table, you may resort to first solution.


Jey Geethan

Jey Geethan is a poet, author and an entrepreneur.


Related Articles

Software Development

What's next after Chatbots?

by Jey Geethan | December 08, 2018
What's next after Chatbots?
Chatbots are programmatically defined workflows that can help any customer to navigate some scenarios. But will chatbots stay there?
Software Development

Do you want to use your macbook as a lap-heater?

by Jey Geethan | August 28, 2019
Do you want to use your macbook as a lap-heater?
How many times have you felt the coldness of a meeting room and wish you had brought a heater into the room. Now you can convert your macbook into a heater