dotnet academic: Update Fail -- dotnet academic

Update Fail

Neo
1/31/2006 10:17:31 AM

dotnet academic: Trying to update a database via a datagrid. I make changes to the grid and
the code then picks up the changes but when I call the update statement, it
fails because it isn't returning any 'key column' information: here is the
error - -- -

Additional information: Dynamic SQL generation for the UpdateCommand is not
supported against a SelectCommand that does not return any key column
information.

If anybody can help with this error it would be appreciated
Thanks

Re: Update Fail

pvdg42
1/31/2006 1:40:40 PM

[quoted text, click to view]
Have you checked the SELECT command to see if it returns the primary key
field(s) for the table in question?
It appears that your update is failing because the update does not have the
unique primary key for the row to be updated.
If we can assume you are loading a DataSet object and underlying DataTable
object(s), then populating a DataGrid, does the DataTable in question
include the primary key column(s) from the table to be updated?