Query against a DataSet

[dotnetprogrammer]

Can you execute query against a DataSet?

I do not mean calling the Filter() function; I mean executing an SQL query with COUNT, SUM and GROUP BY command.
Is it possible? If not, is there a way around?
Thanks,
fred

 

[obislavu]

The true one, you cannot but SUM, COUNT, AVG, Min,Max, StDev ... and other functions could be done using DataColumn.Expression property.
Example:
m_DataTable.Columns("NumOfRecords").Expression = "Count(CustomerID)";
m_DataTable.Columns("ZipCode").Expression = "SUBSTRING(Address,15,7)";
I think if you combine calculated columns and using Sort on DataView you could achive group by.
-obislavu-