Is it possible using SQL 7 (either through VS.NET or Stored procedures) to have datagrid give different counts from a database? I&#039;ll explain.. If I had a table with widgets, different colors, different sizes etc... and I wanted to have one table on my ASPX page that showed Count(*) for Total number of widgets, total number meeting one set of criteria and total number meeting another set of criteria, what would be the best way to do this? This datagrid would have (column1) all the possible widget types listed down the left. 2nd column would be titled total and have Count(*) each color of widget. 3rd column (and this is where it gets hard) would have Total number of small round widgets (even if there were 0 black ones, I would want that listed). Does this make any sense? Can anyone help?<BR>