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

12 Mar 2007 9:18 AM

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

13 Mar 2007 5:10 AM

RobinS

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.
-------------------------------
Show quote

"nvx" <nvx2***@hotmail.com> wrote in message
news:1173691099.992286.247790@h3g2000cwc.googlegroups.com...
> 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
>

13 Mar 2007 5:38 AM

Cor Ligthert [MVP]

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

Show quote

"nvx" <nvx2***@hotmail.com> schreef in bericht
news:1173691099.992286.247790@h3g2000cwc.googlegroups.com...
> 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
>

13 Mar 2007 5:10 PM

nvx

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

With regards
nvx

Cor Ligthert [MVP] napsal:
Show quote

> 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
>
> "nvx" <nvx2***@hotmail.com> schreef in bericht
> news:1173691099.992286.247790@h3g2000cwc.googlegroups.com...
> > 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
> >