Multi-table DataSet...Select statement??

Hi,

I am fairly new to DataSets and such and am hoping there is am obvious
answer to my problem.

I am retrieving data from XML and dumping it into an dataset. The resulting
dataset contains 4 related tables, that is, the data relations are already
there.

Now to my problem. I want to be able to select only certain colunms of data
from accross the tables in the dataset. Basically, I just need to do a
T-SQL like multi-table join. Is there a way to retrieve my records in this
way? The idea is to retrieve only the columns of data I need and then
insert them into my database. If not possible, perhaps using a dataset is
the wrong way to go.

Any help would be greatly appreciated.

Thanks.

-Phil

Andy
Thu May 13 20:06:39 CDT 2004

I think the Select method of the DataTable class would work for you.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemdatadatatableclassselecttopic2.asp

You'll want to check out expressions, specifically the Parent/Child Relation
Referencing section.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemdatadatacolumnclassexpressiontopic.asp

"Phil Robertson" <red66pony@hotmail.com> wrote in message
news:OZq0isROEHA.2468@TK2MSFTNGP11.phx.gbl...
> Hi,
>
> I am fairly new to DataSets and such and am hoping there is am obvious
> answer to my problem.
>
> I am retrieving data from XML and dumping it into an dataset. The
resulting
> dataset contains 4 related tables, that is, the data relations are already
> there.
>
> Now to my problem. I want to be able to select only certain colunms of
data
> from accross the tables in the dataset. Basically, I just need to do a
> T-SQL like multi-table join. Is there a way to retrieve my records in
this
> way? The idea is to retrieve only the columns of data I need and then
> insert them into my database. If not possible, perhaps using a dataset is
> the wrong way to go.
>
> Any help would be greatly appreciated.
>
> Thanks.
>
> -Phil
>
>