I have programmatically generated a DataTable in ASP.NET 3.5 and now I want to use group by and do some calculations using SQL on this DataTable. My question is: Is it possible to write a new SQL query against this DataTable and generate a new updated DataTable? For eg: select ID,sum(Rate) from dataTable group by ID

Sumit Kathuria