Click here to Skip to main content
13,004,823 members (65,871 online)
Rate this:
Please Sign up or sign in to vote.
I have this method in the footer of gridview

<asp:TemplateField HeaderText="SALARY">
                  <asp:Label ID="sal1" runat="server" Text='<%# Eval("Total") %>'></asp:Label>
<%--            <asp:BoundField DataField="Total" HeaderText="totalprice" />
--%>            <FooterTemplate>
           <%# gettotal()%>

now inside this method I want to calculate the total how to get the values from all cells which in the total column in gridview ??

public int gettotal()
      int totalsal = ;
      return totalsal;
Posted 29-Apr-12 6:17am
Shahin Khorshidnia 29-Apr-12 12:38pm
Is the GridView bound to a Collection or something else? Is yes why don't you calculate the total from the Collection?
sara besho 29-Apr-12 17:30pm
what did you mean??
SAKryukov 29-Apr-12 19:45pm
You need to read about binding, to start with...
Rate this: bad
Please Sign up or sign in to vote.

Solution 1

losmac 29-Apr-12 14:10pm
Good links! My 5
Sandeep Mewara 29-Apr-12 14:21pm
Thanks losmac. :)
VJ Reddy 29-Apr-12 21:04pm
Good references. 5!
Sandeep Mewara 30-Apr-12 0:24am
Thanks VJ.
Rate this: bad
Please Sign up or sign in to vote.

Solution 2

Here is Example to total in footer............
protected void grdGuestTotal_RowDataBound(object sender, GridViewRowEventArgs e)
        if (e.Row.RowType.Equals(DataControlRowType.Footer))
            //String NetSubTotal = string.Empty;
            // String SubTotal = string.Empty;
            Label NetSubTotal = ((Label)e.Row.FindControl("lblNetSubTotal"));
            Label FinalTotal = ((Label)e.Row.FindControl("lblTotal"));
            NetSubTotal.Text = Total.ToString();
            FinalTotal.Text = EndTotal.ToString();// (Convert.ToDouble(NetSubTotal.Text) + Convert.ToDouble(SubTotal.Text)).ToString();
        if (e.Row.RowType.Equals(DataControlRowType.DataRow))
            //String NetSubTotal = string.Empty;
            // String SubTotal = string.Empty;
            Label SubTotal = ((Label)e.Row.FindControl("lblSubTotal"));
            Label NetTotal = ((Label)e.Row.FindControl("lblNetTotal"));
            double value = Convert.ToDouble(SubTotal.Text);
            Total += value;
            double amount = Convert.ToDouble(NetTotal.Text);
            EndTotal += amount;

[EDIT]CODE tags added - LOSMAC[/EDIT]
sara besho 29-Apr-12 17:29pm
thank you so much but i didn't get the total from database it doesn't work for me

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web02 | 2.8.170627.1 | Last Updated 29 Apr 2012
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100