Click here to Skip to main content
15,902,198 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
Dear Friends,

Have a Good Day !!

How to do Total sum in Gridview Footer in Asp.net C# ?
=======================================

I have a Gridview which has the fields like UserName, Login Time , Logout Time , Duration. I need to do total duration of hours in footer

UserName | Login Time | Logout Time | Duration


These are my Fields in my Gridview

So, Please help me how to do Total Duration Calculations in Gridview Footer .

thanks in Advance.
Posted

 
Share this answer
 
v2
C#
decimal a = 0;
            Int32 y = GridView1.Items.Count;
            for (Int32 i = 0; i < y ; i++)
            {

                a = a + Convert.ToDecimal(((Label)GridView1.Items[i].FindControl("lbl_subtoprice")).Text.ToString());

            }

            lbl_grandtotal.Text = Convert.ToString(a);

lbl_subtopricel id of your durations values
and
lbl_grandtotal is id of label in footer
 
Share this answer
 
Comments
Karthik_Mahalingam 30-Dec-13 3:56am    
good try.
Omprakash Kukana 30-Dec-13 3:57am    
thanx
JavaScript
var result = from p in st.prices select new {
            p.id,
              p.Name,
               p.price1 };
            GridView1.DataSource = result;
            GridView1.DataBind();
            double sum=0;
            foreach(var item in result){

                sum += Convert.ToDouble(item.price1);
            }
            Label lblsum = (Label)GridView1.FooterRow.FindControl("Lbltotal");
            lblsum.Text = sum.ToString();
 
Share this answer
 
v2
Comments
Karthik_Mahalingam 30-Dec-13 3:55am    
good try..
Karthik_Mahalingam 30-Dec-13 3:57am    
always put your code in code block...
 
Share this answer
 
Comments
__TR__ 27-Aug-12 2:25am    
My 5!
Karthik_Mahalingam 30-Dec-13 3:57am    
nice links.
Mohamed Mitwalli 27-Aug-12 2:28am    
Thank you TR :)
Mohamed Mitwalli 30-Dec-13 4:22am    
Thanks Karthik :)

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