Net-informations.com
SiteMap  | About    

SubTotal and GrandTotal in GridView



In the following lesson, you can learn how to implement a grouping and calculate subtotal for each group and GrandTotal for all groups in ASP.Net GridView.

subtotal and grandtotal in gridview

Database

In this article I have used Microsoft's Pubs database for sample data. You can download it free from the following link.

Download

A subtotal is a total of the subgroup values and a grand total is a total of all calculations on a report. Here we retrieves data from the STOR table of PUBS databae and find the subtotal of quantities from each store and finally find the GrandTotal of quantity from all stores.

For displaying quantity on each row we insert an ItemTemplate for quantity field.

subtotal and grandtotal

For displaying GrandTotal at the footer, we insert a FooterTemplate at thebottom of the GridView.

 grandtotal footer

And for displaying subtotal , the program dynamically add a new row after each group in the Gridview.

Default.aspx

C# Source Code

VB.Net Source Code








net-informations.com (C) 2019    Founded by raps mk
All Rights Reserved. All other trademarks are property of their respective owners.