Running Total In Gridview Footer In ASP.NET C# VB.NET

In this example i am going to demonstrate how to Display Running Total In GridView Footer Row In ASP.NET using C# and VB.NET. This method works with paging enabled gridview as well.

For demo purpose gridview is populated using sqldatasource having table with columns ID ,Name,Amount

I m showing total of amount column is gridview footer. for this we need to sum the the column in RowDataBound Even of Gridiew

Html source of gridview is

<asp:GridView ID="GridView1" runat="server" 
              AutoGenerateColumns="False"
              DataKeyNames="ID" DataSourceID="SqlDataSource1" 
              OnRowDataBound="GridView1_RowDataBound" 
              ShowFooter="True" AllowPaging="True" PageSize="5" 
              BackColor="#ffffff" BorderColor="AliceBlue" 
              BorderStyle="None" BorderWidth="1px" 
              CellPadding="3" 
              CellSpacing="2" FooterStyle-BackColor="#da821e" 
              FooterStyle-ForeColor="#ffffff" 
              RowStyle-BackColor="#003366" 
              RowStyle-ForeColor="#ffffff" 
              AlternatingRowStyle-BackColor="#da821e">
<Columns>
     <asp:BoundField DataField="ID" HeaderText="ID" 
                     InsertVisible="False" ReadOnly="True"
                     SortExpression="ID" />
     <asp:BoundField DataField="Name" HeaderText="Name" 
                     InsertVisible="False" ReadOnly="True"
                     SortExpression="Name" FooterText="Total"/>
     <asp:TemplateField HeaderText="Amount">
     <ItemTemplate>
     <asp:Label ID="lblAmount" runat="server" 
                Text='<%# "$"+Eval("Amount").ToString()%>'>
     </asp:Label>
     </ItemTemplate>
     <FooterTemplate>
     <asp:Label ID="lblTotal" runat="server"></asp:Label>
     </FooterTemplate>
     </asp:TemplateField>
     </Columns>
     <PagerStyle ForeColor="#8C4510" HorizontalAlign="Center" />
     <HeaderStyle BackColor="#da821e" Font-Bold="True" 
                  ForeColor="White" />
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" 
ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
SelectCommand="SELECT [ID], [Name], [Amount] FROM [Expenses]">
</asp:SqlDataSource>

Now we need to write code for summing the column in RowdataBound Even of GridView

C# code behind

show source

01public partial class _Default : System.Web.UI.Page

02{

03    decimal grdTotal = 0;

04    protected void Page_Load(object sender, EventArgs e)

05    {

06 

07    }

08protected void GridView1_RowDataBound

09                   (object sender, GridViewRowEventArgs e)

10{

11 if (e.Row.RowType == DataControlRowType.DataRow)

12 {

13  decimal rowTotal = Convert.ToDecimal

14              (DataBinder.Eval(e.Row.DataItem, "Amount"));

15  grdTotal = grdTotal + rowTotal;

16 }

17 if (e.Row.RowType == DataControlRowType.Footer)

18 {

19  Label lbl = (Label)e.Row.FindControl("lblTotal");

20  lbl.Text = grdTotal.ToString("c");

21 }

22}

23}

VB.NET code behind

show source

01Public Partial Class _Default

02    Inherits System.Web.UI.Page

03    Private grdTotal As Decimal = 0

04    Protected Sub Page_Load

05    (ByVal sender As Object, ByVal e As EventArgs)

06 

07End Sub

08 

09Protected Sub GridView1_RowDataBound

10(ByVal sender As Object, ByVal e As GridViewRowEventArgs)

11 

12If e.Row.RowType = DataControlRowType.DataRow Then

13Dim rowTotal As Decimal =

14Convert.ToDecimal(DataBinder.Eval(e.Row.DataItem, "Amount"))

15grdTotal = grdTotal + rowTotal

16End If

17 

18If e.Row.RowType = DataControlRowType.Footer Then

19Dim lbl As Label = DirectCast(e.Row.FindControl

20                           ("lblTotal"), Label)

21lbl.Text = grdTotal.ToString("c")

22End If

23End Sub

24End Class

Hope this helps

Other gridview articles:
Populating dropdown based on the selection of first drop down in DetailsView using FindControl and ItemTemplate

Pouplating Multiple DetailsView based on single GridView using DataKeyNames

Merging GridView Headers to have multiple Headers in GridView

Search Records In GridView And Highlight Results Using AJAX ASP.NET

Insert update Delete record in GridView using SqlDataSource ItemTemplate and EditItemTemplate

Tweet

If you like this post than join us or share