I have a SQL table containing following column:
date_shipped, product, quantity
In a C# asp.net application, I want to display the data as below:
11/1/2005
prod A 5000
prob A 3000
prod B 2000
----------------
Total 10000
11/2/2005
prod A 2000
prob A 3000
prod B 2000
----------------
Total 8000
---------------------------------------------
AllTotal 18000
What is the best way to loop through the data and display as above I can retrieve data in dataset or any other recommended format. Thanks for your time!

How to display totals
clehnert
For ASP.NET specific questions, please post the ASP.NET forums (http://forums.asp.net/).
Thanks!
Karen