Hi,
I guess what you would want is the ability to JOIN two datatables. If so, I'm not quite sure if this is available currently in ADO.Net but I've seen this feature on the upcomming LINQ Project. See it here:
http://www.microsoft.com/belux/msdn/nl/community/columns/himschoot/linq.mspx
There is a sample there that joins 2 collections based on a query, very similar to INNER JOINS in sql. Since DataTables are also collections then you can now create a view-type datatable...
cheers,
Paul June A. Domag
|