Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can you update 2different tables with one oleDbCommand?

Status
Not open for further replies.
mbutch

mbutch

Programmer
Nov 17, 2000
100
US
I have an oleDbDataAdapter select command that joins 2 tables. I then fill a dataset and attach it to a datagrid. Is there a way to update both tables in the oleDbDataAdapter update command? I tried separating the UPDATE text with a semi colon, which didn't return any errors, but the data doesn't get updated for both tables.

Thanks,

Mike
 
Status
Not open for further replies.

Similar threads

peac3
  • Locked
  • Question
close teradata connection session to dispose volatile tables
Replies
4
Views
702
peac3
peac3
gbaughma
  • Locked
  • Question
Can someone explain....
Replies
1
Views
344
xwb
xwb
WomanPro
  • Locked
  • Question
Crystal report doesn't display all records of the datagridview but olny the last one.
Replies
1
Views
390
hilfy
hilfy
xarzu
  • Locked
  • Question
How do I set up a new computer to run an executable I have built with Microsoft Visual Studio?
Replies
1
Views
520
gbaughma
gbaughma
NoCoolHandle
  • Locked
  • Question
working with SQL "FOR JSON AUTO
Replies
2
Views
454
NoCoolHandle
NoCoolHandle

Part and Inventory Search

Sponsor

Back
Top