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

Question

0.00/5 (No votes)

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

Ranjith Reddy CSE

Add a Solution

4 solutions

Add a Solution

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

awaisshabir · Answer 1 · 2013-12-29T20:50:00

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();

SumitChandra · Answer 2 · 2013-12-30T00:00:00

Solution 4

http://www.aspdotnet-suresh.com/2011/02/how-to-display-sum-of-columns-total-in.html[^]

HOPE THIS WILL HELP YOU A LOT

Posted 30-Dec-13 0:00am

SumitChandra

Updated 30-Dec-13 0:01am

v2

Mohamed Mitwalli · Answer 3 · 2012-08-26T20:17:00

Solution 1

Hi ,
Check this
display total hours in gridview footer C#[^]
http://catalog.codeproject.com/Answers/414447/Sum-of-an-Gridview-Column-should-be-shown-in-the-l?cmt=282206#answer1[^]
Sum of an Gridview Column should be shown in the last row of Bottom in Gridview[^]
sum of column values in c sharp[^]
Best Regards
M.Mitwalli

Posted 26-Aug-12 20:17pm

Mohamed Mitwalli

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 :)

Omprakash Kukana · Answer 4 · 2013-12-29T21:07:00

Solution 3

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

Posted 29-Dec-13 21:07pm

Omprakash Kukana

Comments

Karthik_Mahalingam 30-Dec-13 3:56am

good try.

Omprakash Kukana 30-Dec-13 3:57am

thanx

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

4 solutions

Solution 2

Solution 4

Solution 1

Solution 3

Add your solution here

Preview 0

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

4 solutions

Solution 2

Solution 4

Solution 1

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us