Click here to Skip to main content
13,199,852 members (71,935 online)
Rate this:
Please Sign up or sign in to vote.

I currently have a dataset which contains data from 4 separate tables. The reason the dataset contains data from the 4 tables is in order for the data to be more reader friendly i.e. I have a table which contains descriptions based off an I.D. and I have another table which just contains the I.D. so the join gets the description from the table that I do not want to update and inserts it into the dataset so the user can select the description and not have to care about the I.D. THe issue im running into is when attempting to update the dataset given the

adapter.SelectCommand = New OdbcCommand(query, conn)
        Dim builder As OdbcCommandBuilder = New OdbcCommandBuilder(adapter)

I am obviously getting an error stating that the datafields do not match i.e. the description isn't a number and therefore can't be entered as an I.D. Does anyone have any idea of how I could possibly tell the updater to reference the other table for the I.D. using the given description?
Posted 21-Jul-12 13:57pm

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

You'll have to write you own SQL statemnet and build the SqlCommand object yourself.

The CommandBuilder will NOT build UPDATE query statements from SELECT statements that contains any kind of JOINs.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy |
Web01 | 2.8.171020.1 | Last Updated 21 Jul 2012
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100