Hi,
There is a table with columns itemcode (varchar), itemprice (money) and dateofsale (datetime). need to display the same within gridview where it should be as below
Year Month Amount Grade
------------------------------------------------------
2009 April $ 5,300.00 A
2009 July $ 5,500.00 A
2008 November $ 1,500.00 B
Total $ 12,300.00
Average $ 4,100.00
can any one help me...
Regards,
Rajendra