Devart Forums

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 ??

I didn't have primary key in my table .

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.