How do I update a database from a dataset with SQL "JOIN" using CommandBuilder...
The problem appears when I try to update from a dataset made from SQL with "JOIN"...
:confused:
Printable View
How do I update a database from a dataset with SQL "JOIN" using CommandBuilder...
The problem appears when I try to update from a dataset made from SQL with "JOIN"...
:confused:
Check how many columns you have in the table. The CommandBuilder is designed for "normalized" tables less than 101 columns. Maybe you JOIN gives you more
You can't use the CommandBuilder on SQL statements that contain a JOIN, only on single table SQL statements.
A quote from the MSDN library:
"Automatically generates single-table commands used to reconcile changes made to a DataSet with the associated SQL Server database."
OK... Thank you. :mad: