Click here to Skip to main content
15,851,514 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
I have this method in the footer of gridview

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

           <%# gettotal()%>

         </FooterTemplate>
         </asp:TemplateField>


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 ??

C#
public int gettotal()
  {

      int totalsal = ;

      return totalsal;

  }
Posted
Comments
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?
Sarah Mohammed77 29-Apr-12 17:30pm    
what did you mean??
Sergey Alexandrovich Kryukov 29-Apr-12 19:45pm    
You need to read about binding, to start with...
--SA

 
Share this answer
 
Comments
Maciej Los 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.
Here is Example to total in footer............
C#
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]
 
Share this answer
 
v2
Comments
Sarah Mohammed77 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)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900