Unfortunately, the current architecture in ADO.NET, does not support set-based access to the in-memory DataSets: in other words, it is not possible to execute SQL statements against tables within a DataSet. This means that you can't create on the fly queries that pull from different DataTables. The DataView object allows you to work with one DataTable, allowing sorting and filtering but you need to get all your data into that DataTable for this to work.
>Suppose I run a big SQL query in SQL Server, and bring back the data as an ADO.NET dataset.
>
>Does ADO.NET have the capability for me to actually run an SQL statement against the ADO.NET dataset?
>
>There are times where I'd like to take the data I pull back from SQL Server, and 'slice/dice/group' it further with a subsequent SQL-like statement. Can this be done?
>
>Thanks,
>Kevin
-----------------------------------------
Cathi Gero, CPA
Prenia Software & Consulting Services
Microsoft C# / .NET MVP
Mere Mortals for .NET MVP
cgero@prenia.comwww.prenia.comWeblog: blogs.prenia.com/cathi