Multi-table DataSet...Select statement??

[Phil Robertson]

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 Gaskell]

I think the Select method of the DataTable class would work for you.
http://msdn.microsoft.com/library/d...frlrfsystemdatadatatableclassselecttopic2.asp

You'll want to check out expressions, specifically the Parent/Child Relation
Referencing section.
http://msdn.microsoft.com/library/d...fsystemdatadatacolumnclassexpressiontopic.asp