DataGridView - Columns sum in real time

Question

0.00/5 (No votes)

See more:

Hi all,

I have a problem where I have a DataGridView with invoice information. One of the columns is the price of a service.

Right below this I have a label that needs to show the total value of this invoice, and it needs to be shown as the user types the values.

e.g.

Service | Value
Hotel | $200.00

Total: $200.00

After typing the next entry...

Service | Value
Hotel | $200.00
Taxi | $50.00

Total: $250.00

Also, I don't know how to use events. So, if you can explain me how to declare an event...

I know I must use method for this (e.g. private void dgrid_CellValueChanged(object sender, DataGridViewCellEventArgs e){ ... } ), but I don't know how to make this method to be called when there is a cell updating, in fact.

After this, when I try to use the solution proposed for Pawan, I got the following error:

"Object reference not set to an instance of an object."

On the line:

double V = string.IsNullOrEmpty(dgrid.Rows[i].Cells["Service"].Value.ToString()) ? 0 :Convert.ToDouble(dgrid.Rows[i].Cells["Service"].Value);

PS: I set this column as typeof(double) in the Form Load event and I am also using a column format as C2(currency). In this case, after entering the value, it puts the symbol $ in front of the value. Also, when I type something in one of the columns, a new line is automatically created.

Can someone help me? :confused:

Thanks in advance! ;)

Posted 28-Oct-10 23:00pm

lucasgrohl

Updated 31-Oct-10 20:20pm

v6

Add a Solution

Comments

Dalek Dave 29-Oct-10 5:04am

Edited for Grammar.

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

Member 10705109 · Answer 1 · 2014-03-31T13:30:00

i put this code in the datagridview1_CellEnter event

if (e.ColumnIndex == 4)//4 is the column that you want to add up in real time
{
double sum = 0;
foreach (DataGridViewRow item in dataGridView1.Rows)
{
if (!item.IsNewRow)
{
sum += Convert.ToDouble(item.Cells[4].Value.ToString());
label1.Text = "" + sum;
}
}

}

Mohd Wasif · Answer 2 · 2010-10-28T23:23:00

SqlDataAdapter adap = new SqlDataAdapter("select sum(Price)as Total from ASSSS where Invoice=1", MyConnection);
MyConnection.Open();
// DataSet ds = new DataSet();
DataTable dt = new DataTable();
adap.Fill(dt);

if (dt.Rows.Count > 0)
{

Label1.Text = dt.Rows[0]["Total"].ToString();
}

MyConnection.Close();
Use it

Mohd Wasif · Answer 3 · 2010-10-29T01:06:00

Solution 4

http://aspalliance.com/782

Follow this kink u will get the code of ur problem

Posted 29-Oct-10 1:06am

Mohd Wasif

Comments

lucasgrohl 29-Oct-10 7:15am

The problem is that this is for when I already have the data stored. In my case, the user is typing the values and the sum of all the cells of this columns has to be shown in run time in a label. =/

DataGridView - Columns sum in real time

3 solutions

Solution 5

Solution 2

Solution 4

Add your solution here

Preview 0