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
Relaxing Constraints for a data table adapter

I'm trying to relax my constraints while using a data table adapter, but I'm getting a Object reference not set to an instance of an object error. It happens on the line that says ds.DataSet.EnforceConstraints = false; Generally, I …

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