How to Calculate Total Column in Gridview ? ?

Question

0.00/5 (No votes)

See more:

Dear Frnds !!

I have a Gridview on my webform. Finally i have filled it with database.

I this Gridview Records will be filled with Form, This forms it contains Textboxes and Button.
and these Textboxes value will be filled in gridview when submit button clicks after entering text and numbers into textbox...so its Inserting Well.

But now i need Total Amount at bottom.

Example Gridview Display
========================

HTML

Name        Item         Amount
-----       ----         ------  
Raju       Laptop         15000
Varun      HandyCam       12000
Teja       Iphone         18000
Ranjith     PC            22000

Now We need Total Amount Automatically below.

Please show me, how to do total amount in Gridview.

Thanks.

Posted 21-May-12 20:20pm

Ranjith Reddy CSE

Updated 21-May-12 20:48pm

Anuja Pawar Indore

v2

Add a Solution

Comments

John Orendt 22-May-12 2:38am

Please show the code that populates the DataGridView.

Anuja Pawar Indore 22-May-12 2:48am

Formatting of ques done

7 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

sagar wasule · Answer 1 · 2012-05-21T20:54:00

Solution 3

C#

int sum = 0;
foreach(DataRow dr in datatable.Rows)
{
    sum = sum + Convert.ToInt32(dr["Amount"]);
}

sum variable will contain the total of all the values.Use this 'sum' where ever u need.

chk this out ....

Posted 21-May-12 20:54pm

sagar wasule

Updated 22-May-12 0:52am

v2

Prasad_Kulkarni · Answer 2 · 2012-05-21T21:08:00

You can use CellValidated[^] event and place your calculations in there.

Also refer following threads:

This article demonstrates how to develop client side calculations in a GridView, and calculation expressions are configurable at the DB side:
Database driven client side calculations in GridView[^]

Using JavaScript/JQuery:
Calculating GridView total using JavaScript/JQuery[^]

How To Add client side calculation for gridview column[^]
How to Display Sum Total in the Footer of the GridView Control[^]

GridView Examples for ASP.NET: Displaying Summary Data in the Footer[^]
Displaying Summary Information in the GridView's Footer[^]

Check similar discussion on following link:
Calculate Total Value In Gridvew In ASP.net C#[^]

Hope you get some needful from it!

Technoses · Answer 3 · 2012-05-21T21:42:00

Solution 5

You should use FooterRow of gridview then
after databind you can write this line

C#

GridView.FooterRow.Cells[2].Text = ds.Tables[0].Compute("sum(Amount)", "").ToString();

Posted 21-May-12 21:42pm

Technoses

Nilesh Patil Kolhapur · Answer 4 · 2012-05-21T20:38:00

Hi,

yes you can solve your problem using row databound event of gridview

C#

void CustomersGridView_RowDataBound(Object sender, GridViewRowEventArgs e)
  {

    if(e.Row.RowType == DataControlRowType.DataRow)
    {
     
          int amount=int.Parse( e.Row.Cells[2].Text) ;

//your calculation

    }

  }

Hope it helps u
best Luck
Happy Coding:)

Anuja Pawar Indore · Answer 5 · 2012-05-21T20:53:00

Solution 2

Refer this link

http://www.beansoftware.com/ASP.NET-Tutorials/Total-GridView-Footer.aspx[^]
http://www.ezzylearning.com/tutorial.aspx?tid=1676759[^]

Posted 21-May-12 20:53pm

Anuja Pawar Indore

RempoRaaj · Answer 6 · 2012-05-22T01:00:00

XML

function CalculateTax(fixedtotal)
  {
    var taxgrid = document.getElementById('<%=gvAttribute.ClientID %>');
    var taxip = taxgrid.getElementsByTagName('input');
    var taxamount = 0*1;

    for(i = 0; i < taxip.length; i+= 2)
    {
        var sign = taxip[i].value;
        var tax = taxip[i+1].value;
        taxamount = parseFloat(taxamount) + (sign =='+' ? 1 : -1)* parseFloat(tax);
    }
    return parseFloat(fixedtotal) + parseFloat(taxamount);
  }

Here it is your model for more information visit <a href="http://stackoverflow.com/questions/6288504/how-to-calculate-the-sum-of-gridview-columns-using-javascript"><b>
<b><b></b></b>http://stackoverflow.com/questions/6288504/how-to-calculate-the-sum-of-gridview-columns-using-javascript</b></a>[<a href="http://stackoverflow.com/questions/6288504/how-to-calculate-the-sum-of-gridview-columns-using-javascript" target="_blank" title="New Window">^</a>]

walshregal · Answer 7 · 2014-03-04T18:40:00

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
Label lblqy = (Label)e.Row.FindControl("lblqty");
int qty = Int32.Parse(lblqy.Text );
total = total + qty;
}
if (e.Row.RowType == DataControlRowType.Footer)
{
Label lblTotalqty = (Label)e.Row.FindControl("lblTotalqty");
lblTotalqty.Text = total.ToString();
}
}

More Info : GridView Total on Footer

Walsh.

How to Calculate Total Column in Gridview ? ?

7 solutions

Solution 3

Solution 4

Solution 5

Solution 1

Solution 2

Solution 6

Solution 7

Add your solution here

Preview 0