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?
Thanks
Raif

The query you use in .NET is dependant on the underlying database system. If you are using MSSQL, feel free to use any MSSQL specific syntax. ADO.NET shouldn't restrict you. The [] you might see are again a database specific syntax. In MSSQL (and probably others) if you give a field or table a name that matches one of the MSSQL keywords you would wrap it in [] so MSSQL knows you mean a field or table name. (i.e.: SELECT [SELECT] FROM [SELECT])