The question was in regards to selecting from multiple DataTables and create a new DataView. Kamal Patel just wrote an article about how to leverage VFP to accomplish this. You can use the DataTable to create a DataView but as far as I know you can't pull from different DataTables to create the DataView.

>I think you can do that with ADO.NET using the Select method on the Tables collection which returns you a set of rows from the existing data.
>
>I just can't remember whether it works only on a single table current table (ie. it's a table property) or whether you can run it across tables (ie. it's part of the Tables collection). I think both are available actually...
>
>Can't check this second though...
>
>+++ Rick ---
>
>>That would be a great feature to have native in .NET. We have been spoiled by all the great features in VFP and notice how much we miss them when they are taken away.
>>
>>>Cathi...
>>>
>>>I read the article you mentioned...this capability is a god-send for me, because I frequently need to do further 'data munging' on result sets.
>>>
>>>A question - what are the odds that (anytime soon) someone will release a provider for ADO.NET that allows native set-based queries of data tables?
>>>
>>>Thanks,
>>>Kevin