Join on two data tables in same dataset

[Guest]

I have one dataset. Filled one DataTable from dbase. Filled another DataTable
using ReadXml() and Merge(). So now I have to DataTables that I want to Join
on that exist in memory but are from disparate data sources. Can I Join on
them with ADO.NET?

Thanks.

 

[Sahil Malik [MVP]]

If the two datatables are in the same dataset, you can create datarelations
between them, and use the GetChildRows, GetParentRow methods to do something
similar to joins.

- Sahil Malik [MVP]
http://codebetter.com/blogs/sahil.malik/