Using Linq with datatables

you need a reference to datasetextensions.

the interesting thing was that was enough to bring up "where" and "order by"clauses but not group by - for that I needed a using system.linq