Sql statements in data adapter
can you use all the same sort of select query functions in ado.net as you can in sql server? for instance I want to pull a dataset from a database using a sql statement that groups by and counts different columns. This statement works in sql server "SELECT PKDate, COUNT(S1Tr) AS S1Sum, COUNT(S2Tr) AS S2Sum, COUNT(S3Tr) AS S3Sum FROM(tblSlots)GROUP BY PKDate"
it groups by pkdate and creates new columns S1Sum etc as counts of S1Tr etc. but my asp.net page will have none of it.
Also where can I get the syntax and restrictions for my select statements in .net? I have seen all manner of different versions such as using  on all tables and fields. including the table.field for every field even if you are only using one field etc. Is there some comprehensive rule set somewhere?