CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 4 of 4
  1. February 18th, 2003, 04:22 PM #1
    erezrave
    erezrave is offline Member
    Join Date
    Feb 2003
    Location
    Israel
    Posts
    40

    Updating database using CommandBuilder

    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"...

    Reply With Quote Reply With Quote
  2. February 18th, 2003, 04:27 PM #2
    Iouri
    Iouri is offline Elite Member
    Join Date
    May 2000
    Location
    New York, NY, USA
    Posts
    2,878
    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
    Iouri Boutchkine
    [email protected]
    Reply With Quote Reply With Quote
  3. February 19th, 2003, 02:41 AM #3
    DdH
    DdH is offline Member
    Join Date
    Jan 2003
    Location
    Amsterdam, Netherlands
    Posts
    97
    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."
    Reply With Quote Reply With Quote
  4. February 19th, 2003, 05:30 AM #4
    erezrave
    erezrave is offline Member
    Join Date
    Feb 2003
    Location
    Israel
    Posts
    40

    OK

    OK... Thank you.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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

Featured