How To Find The Total Sum Of Particular Column In Gridview Using C#

Question

1.00/5 (1 vote)

See more:

C#

ASP.NET

How To Find The Total Sum Of Particular Column in Gridview Using C#

Posted 5-May-13 23:37pm

Seshu The Baadshah

Updated 18-Mar-17 21:28pm

Add a Solution

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

vijay__p · Answer 1 · 2013-05-05T23:49:00

Solution 1

You can iterate through GridViewRow and find particular control in which number is displayed and do summation of it as below.

C#

var total = 0;
            foreach (GridViewRow row in GridView1.Rows)
            {
                var numberLabel = row.FindControl("ID of Label") as Label;
                int number;
                if (int.TryParse(numberLabel.Text, out number))
                {
                    total += number;
                }
            }

            // Sum in variable total

Posted 5-May-13 23:49pm

vijay__p

Comments

[no name] 6-May-13 5:57am

label id means i have not taken any labels inside the gridview.,

vijay__p 6-May-13 6:01am

Have you used bound column?

vijay__p 6-May-13 6:02am

If you have used bound column then you can use below code
var numberLabel = row.Cells[1].Text; // 1 is the column number in GridView

[no name] 6-May-13 6:03am

i have not used bound column

vijay__p 6-May-13 6:11am

Then what you have used ?

Bikash Prakash Dash · Answer 2 · 2013-05-05T23:53:00

Solution 2

Try this

C#

int sum = 0;
       for (int i = 0; i < GridView1.Rows.Count; i++)
       {
           sum += int.Parse( GridView1.Rows[i].Cells[CellIndex].Text);
       }
       Label1.Text = sum.ToString();

Enter Cell Index as per your requirement, which column you want.

Posted 5-May-13 23:53pm

Bikash Prakash Dash

Comments

[no name] 6-May-13 6:05am

it given the error like:Input string was not in a correct format.

[no name] 6-May-13 6:08am

i want the sum of the 5th column in gridview

int sum = 0;
for (int i = 0; i < grv_Product.Rows.Count; i++)
{
sum += int.Parse(grv_Product.Rows[i].Cells[5].Text);
}

Bikash Prakash Dash 6-May-13 6:10am

for 5th column cell index is 4.

Member 12498070 4-May-16 7:26am

it was a much helpful solution. Thnx a lot!

Thanks7872 · Answer 3 · 2013-05-05T23:54:00

Here is the example. You can implement this in RowDataBound Event of Gridview as follows:

C#

protected void Gridview_RowDataBound(object sender, GridViewRowEventArgs e)
        {
            if (e.Row.RowType == DataControlRowType.DataRow)
            {
                string name= textbox1.text;
                SqlCommand cmd = new SqlCommand("select SUM(leave) from leave_rec where name=@empname",conn);
                cmd.Parameters.Add(new SqlParameter("@empname", name));
                SqlDataReader dr = cmd.ExecuteReader();
                if (dr.Read())
                {
                    Label leave_label = (Label)e.Row.FindControl("your label id");
                    object value = dr.GetValue(0);
                    leave_label.Text = value.ToString();
                }
             }
         }

Here,we have label field(leave_label) as templatefiled in gridview.On Gridview_RowDataBound Event,we have calculated total leaves for particuler employee which will be displayed in label.

josh-jw · Answer 4 · 2013-05-06T00:02:00

Solution 4

check this link
http://social.msdn.microsoft.com/Forums/en-US/windowsuidevelopment/thread/611b6cd8-d74f-4717-b12c-c9658fbdfc31/[^]

Posted 6-May-13 0:02am

josh-jw

Member 12920720 · Answer 5 · 2017-03-18T21:28:00

Sum of Columns of 27 GridViews at once:
protected void Page_Load(object sender, EventArgs e)
{
//== Array of Controls =============================
GridView[] ObjGridViewArray = new GridView[26];
ObjGridViewArray[0] = Gridview4;
ObjGridViewArray[1] = Gridview5;
ObjGridViewArray[2] = Gridview6; ObjGridViewArray[3] = Gridview7;
ObjGridViewArray[4] = Gridview9; ObjGridViewArray[5] = Gridview10;
ObjGridViewArray[6] = Gridview11; ObjGridViewArray[7] = Gridview12; ObjGridViewArray[8] = Gridview13; ObjGridViewArray[9] = Gridview14;
ObjGridViewArray[9] = Gridview16; ObjGridViewArray[10] = Gridview17; ObjGridViewArray[11] = Gridview18; ObjGridViewArray[12] = Gridview19; ObjGridViewArray[13] = Gridview20;
ObjGridViewArray[14] = Gridview21; ObjGridViewArray[15] = Gridview22; ObjGridViewArray[16] = Gridview23; ObjGridViewArray[17] = Gridview24; ObjGridViewArray[18] = Gridview25;
ObjGridViewArray[19] = Gridview26; ObjGridViewArray[20] = Gridview27; ObjGridViewArray[21] = Gridview28; ObjGridViewArray[22] = Gridview29; ObjGridViewArray[23] = Gridview30;
ObjGridViewArray[24] = Gridview31; ObjGridViewArray[25] = Gridview33;
for (int i = 0; i < ObjGridViewArray.Length; i++)
{

sumOfColumnsOfAllGridviews(ObjGridViewArray[i]);
}
}
private void sumOfColumnsOfAllGridviews(GridView ObjGridViewArrays)
{
string valuesG;

for (int c = 0; c < ObjGridViewArrays.Columns.Count; c++)
{
for (int j = 0; j < ObjGridViewArrays.Rows.Count; j++)
{
valuesG = ObjGridViewArrays.Rows[j].Cells[c].Text;
double Num;
bool isNum = double.TryParse(valuesG, out Num);
if (isNum)
{
sum2 = sum2 + decimal.Parse(valuesG);
}
//== Display Total =======================
ObjGridViewArrays.FooterRow.Cells[0].Text = "Total";
ObjGridViewArrays.FooterRow.Cells[c].Text = sum2.ToString();
ObjGridViewArrays.FooterRow.Cells[c].BackColor = System.Drawing.Color.Khaki;
ObjGridViewArrays.FooterRow.Cells[0].BackColor = System.Drawing.Color.Red;
//========================================
}
sum2 = 0;
}
}