Need a solution for displaying sales report in gridview

Posted by Rajendra.prasad under ASP.NET on 5/8/2011 | Points: 10 | Views : 2331 | Status : [Member] | Replies : 4
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




Responses

Posted by: Umeshdwivedi on: 5/8/2011 [Member] Starter | Points: 25

Up
0
Down
hello,populate all the fields in grid view

Latest Technology Trainer
And Part time software consultant

Rajendra.prasad, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Ndebata on: 5/9/2011 [Member] Starter | Points: 25

Up
0
Down
Hi
Take a look at this gridview tutorial.
http://www.dotnetfunda.com/tutorials/controls/gridview.aspx
Thanks,
Debata

Rajendra.prasad, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Prabhakar on: 5/9/2011 [Member] [MVP] Starter | Points: 25

Up
0
Down
Hi Rajendra . .


Check this link . .it's help us u . . i think u want to Total & Average in Ur Gridview


http://msdn.microsoft.com/en-us/library/bb310552.aspx

Best Regard's
Prabhakar

Rajendra.prasad, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Rajendra.prasad on: 5/10/2011 [Member] Starter | Points: 25

Up
0
Down
Thanks for your quick replies

Rajendra.prasad, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response