Update Fail

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Neo - 31 Jan 2006 18:17 GMT

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

Reply to this Message

pvdg42 - 31 Jan 2006 19:40 GMT

> 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,
[quoted text clipped - 9 lines]
> If anybody can help with this error it would be appreciated
> Thanks

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?

Reply to this Message

Update Fail

Free Magazines