How to display totals

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!


Answer this question

How to display totals