Loading

Update Command of Command Builder

bharat

hi,
i'm getting the following when working with update command of command builder
dynamic sql generation for update command is not supported against a select command that doesnt return any key colimn information
my database is mysql and my table has 2 primary keys
Please help me to solve this

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Sanjay Chauhan17y ago
Setting the SelectCommand is not enough. ADO.NET has to execute a query on
the server to return a set of resultsets that are used to generate the CB
UpdateCommand etc. These are not generated immediately--only when
referenced. You do not have to use the GetInsertCommand or any of those
methods to use the generated code. When you execute Update (for the first
time) the generated code is built and used INSTEAD OF the DataAdapter
UpdateCommand etc.