How to Sum the value of gridview and show result at the end of that gridview

Question

1.80/5 (2 votes)

See more:

Hii...

I am working on Windows Application and I am stuck in an issue. Suppose have a gridview in which I have to add the value of a particular column.And at the end of the rows it will display the result.Like,

No. Item Rate

1 Pencil 10
2 Box 20

Total: 30

I have written this code,

C#

private void datagridview_CellValueChanged(object sender, DataGridViewCellEventArgs e)
       {
           if (e.ColumnIndex == 2)
           {
               decimal Total = 0;
               for (int i = 0; i < datagridview.Rows.Count; i++)
               {
                   if (Convert.ToString(datagridview.Rows[i].Cells[2].Value) != "")
                   {
                       decimal GrossAmnt = Convert.ToDecimal(datagridview.Rows[i].Cells[2].Value.ToString());
                       Total = GrossAmnt + Total;
                       datagridview[2, datagridview.Rows.Count].Value = Total.ToString();
                       
                   }
               }


           }
       }

when I execute this it shows me an error;

SQL

Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index

Anybody is there please help me to solve this.

Thanks...

Posted 18-Apr-13 19:57pm

Shivani Dash

Updated 30-Apr-13 21:48pm

Raje_

v3

Add a Solution

Comments

Thomas Barbare 19-Apr-13 2:00am

Your gridView is bind to a database ? or it will be filled by user ?

Shivani Dash 19-Apr-13 2:06am

no its bind to database.

Thomas Barbare 19-Apr-13 2:19am

You have to calculate the total and add a row in your datasource with the result in.

Shivani Dash 19-Apr-13 2:48am

ya...bt the result should show at the end of the gridview row..where the row finished.

1 solution

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)

Sant Osha · Answer 1 · 2013-04-18T20:29:00

Solution 1

C#

int count = 0;
            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
            {
                count = count+ Convert.ToInt32(ds.Tables[0].Rows[i][2].ToString());
            }
            DataRow dr = ds.Tables[0].NewRow();
            dr[0]="";
            dr[1] = "Total::";
            dr[2]=count.ToString();
            ds.Tables[0].Rows.Add(dr);

Posted 18-Apr-13 20:29pm

Sant Osha

Comments

Shivani Dash 19-Apr-13 3:24am

but how to show in grid at perticular that column..?

Sant Osha 19-Apr-13 4:41am

Dude... you just bind the grid after above iteration, just like..
GridView.DataSource = ds;
GridView.DataBind();

Shivani Dash 19-Apr-13 6:15am

have done sumthg.Actually i can add dt data and can show @ the end of grid bt not under that perticular column..it cums under first column.

Sant Osha 22-Apr-13 2:43am

then use insert at option