I am trying to update a table using commandbuilder. I don't have primary key in table. So I set the primary key in datatable, but still it fails and give the following error message:
"Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information."
Can someone please help?
Thanks,