|
-
August 4th, 2009, 09:28 AM
#1
MySqlCommandBuilder SqlCommandBuilder Error
Hi Pr0's,
I have a problem trying to implement the same example from this link:
http://msdn.microsoft.com/en-us/libr...ndbuilder.aspx
But instead of Sql I use MySql. When I fill the DataSet with the data from the DB I dont have any trouble I can even fill also a DataGridViewer and display the data in my form.
The problem is when I want to use the GetUpdateCommand. I get an exception error like "Dynamic SQL generation is not supported against multiple base tables".
So basically I get the Data from the DB and then fill the DataSet and then copy it to the DataGridView. Afterwards I modify manually the rows and then I want to update it.
Why do you think I have this problem? I just copied the code exactly from the MSDN's example and I get this error.
Thank you in advance,
Raul Bolanos.
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
|