|
-
August 6th, 2009, 07:26 AM
#1
Update DATABASE using DataAdapter's update method
Hi guys,
I want to update this datatable into my DB but the table in the DB that I use, it doesn't use Primary Key and I really don't need it. Therefore I get this Exception error (System.InvalidOperationException: Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information).
If I go to the DB and I add a new column into the table and assign it like PK it works but I really want to avoid this and keep the table like that.
Any suggestion please?
Thank you in advance
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|