Is it possible to fill a DataSet.DataTable with values from more than one database table?

  • Thread starter Thread starter nvx
  • Start date Start date
N

nvx

Hello,
is there a way to fill a DataSet.DataTable with values from more than
one table from a single database file? The thing I'd like to achieve
is to get something similar to a result of the JOIN keyword in SQL.

Thanks for any help...

With regards
nvx
 
Not really. You can do some stuff with Expressions to add additional
columns pointing to a separate data table in the same data set with a
foreign key, but you can't do update queries on a dataset, which it sounds
like you're looking for.

You could, of course, also do a join when you originally fill your
datatable.

Robin S.
 
NVX,

Of course you can, but be aware that you cannot use the standard procedurs
from ADONET, you will have to write your own Fill, Update, and Insert
commands or in otherwords Select, Update, Insert, Delete.

Cor
 
Thank you very much for your replies... :) Hopefully I'll manage to
code it... ;)

With regards
nvx


Cor Ligthert [MVP] napsal:
 
Back
Top