Click here to Skip to main content
Rate this: bad
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 14: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
0 Maciej Los 470
1 Sergey Alexandrovich Kryukov 424
2 OriginalGriff 360
3 Abhinav S 250
4 CHill60 240
0 Sergey Alexandrovich Kryukov 10,102
1 OriginalGriff 9,495
2 Peter Leow 5,241
3 Kornfeld Eliyahu Peter 3,373
4 Maciej Los 3,076

Advertise | Privacy | Mobile
Web01 | 2.8.150327.1 | Last Updated 21 Jul 2012
Copyright © CodeProject, 1999-2015
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