13,045,019 members (43,771 online)
Rate this:
Please Sign up or sign in to vote.
See more:
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 26-Aug-12 20:11pm

## 4 solutions

Rate this:
Please Sign up or sign in to vote.

## Solution 2

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();
v2
Comments
karthik mahalingam01 30-Dec-13 3:55am

good try..
karthik mahalingam01 30-Dec-13 3:57am

always put your code in code block...
Rate this:
Please Sign up or sign in to vote.

## Solution 4

v2
Rate this:
Please Sign up or sign in to vote.

## Solution 1

Comments
__TR__ 27-Aug-12 2:25am

My 5!
karthik mahalingam01 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 :)
Rate this:
Please Sign up or sign in to vote.

## Solution 3

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
Comments
karthik mahalingam01 30-Dec-13 3:56am

good try.
Omprakash Kukana 30-Dec-13 3:57am

thanx

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

Top Experts
Last 24hrsThis month
 OriginalGriff 288 ppolymorphe 149 Graeme_Grant 95 kp564 70 Pat O'Brien 50
 OriginalGriff 4,563 RickZeeland 1,844 ppolymorphe 1,698 F-ES Sitecore 1,553 Dave Kreskowiak 1,349

Advertise | Privacy | Mobile
Web02 | 2.8.170713.1 | Last Updated 30 Dec 2013
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