ADO.Net JOIN

[Cliff Harris]

I have two DataTables that I need to join together. I know that I can use a
datarelation to set up the relationship between the two tables and then use
GetChildRows() or GetParentRows() or GetParentRow() to get the related
row(s) based on the datarelation that I set up, but that sure seems like a
big pain to have to loop through each row when all I want is to perform a
simple joina nd return a columns from both tables. Is there some other way
of doing this that I haven't found?

Thanks,
-Cliff

 

[Eric Barr]

ADO.NET is great, but it isn't a full query processing engine. I have not
found a way to do joins, and i don't belive there is any way.

HTH,
-eric