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

c# .net tableadapter
Sam picture Sam · Feb 26, 2009 · Viewed 53.3k times · Source

So I had this working last week. At least, I thought I did! DataGridView Update

Then I start working on the project again today and am getting

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

On 

scDB.SSIS_Configurations_StagingDataTable table = (scDB.SSIS_Configurations_StagingDataTable)stagingGrid.DataSource;
myStagingTableAdapter.Update(table);

The StagingTableAdapter has an additional query which takes 'filter' as a parameter. That was used to fill the DataGridView. In the wizard for creating that query I see 'update was generated'. I see that most posts with this error require that an update statement be generated with a command builder. What do I do?

Answer

Jason picture Jason · Jun 13, 2011

This message will also be displayed caused when you do not have a primary key defined on the table you are updating.

Related questions

Failed to enable constraints. When using a data table adapter

I'm getting Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints. for the following query in my table adapter. select f.id, f.name, p.productid, p.masterproductID, f.productid, f.dateCreated, f.…

Read More
How to make an HTTP POST web request

Canonical How can I make an HTTP request and send some data using the POST method? I can do a GET request, but I have no idea of how to make a POST request.

Read More
How can I convert String to Int?

I have a TextBoxD1.Text and I want to convert it to an int to store it in a database. How can I do this?

Read More