http://www.ondotnet.com/pub/a/dotnet/2003/01/14/groupbyds.html
In many situations, an ADO.NET developer will want to use the Order By and Group By semantic of SQL. This article by Satya Komatineni will show you how to do it. Jan. 14, 2003