mysqlDataAdapter Preview Data error during Update.

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
AceEmbler
Posts: 26
Joined: Fri 04 Aug 2006 09:45

mysqlDataAdapter Preview Data error during Update.

Post by AceEmbler » Wed 09 Aug 2006 09:51

When i change some data in DataAdapter Preview Data.
(I can add data but cennot modify)
and press Update
I have got this error.
"Dynamic SQL generation for UpdateCommand in not supported against a SelectCommand that does not return any key column information"

Can you please explain this to me ?? Is this problem somehow similar to my previous post with exceptions during updating changes made to datagrid ??

AceEmbler
Posts: 26
Joined: Fri 04 Aug 2006 09:45

Post by AceEmbler » Wed 09 Aug 2006 10:23

I didn't have primary key in my table .

Serious

Post by Serious » Wed 09 Aug 2006 11:35

Open MySqlDataAdapter editor, go to "Generator" tab page, press "Get Table Fields", then select all items in "Key Fields" listbox. Then press "Generate Commands". INSERT/UPDATE/DELETE commands will be generated to handle table without key columns.

Post Reply