datagridview cells multiplying

Luka Roguljic

13y3.9kVisual Basic .NET

I have one problem with datagridview. I wanna to multiplying two cellse and displya result in third cell?

example:

A | B | C

10.50 | 2 | 21,00

5.20 | 4 | 20,80

7,3 | 5 | 36,50

after that i wanna to sum C column and display that in textBox.

Column A is type decimal

Column B is integer

Column C should be decimal too

how to do that and how to display decimal value in textbox?

I have found couple solutions on internet but they don't work for me.

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes13y ago
Accepted answer
Try something like this:

decimal sum = 0.0m;

for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
DataGridViewRow row = dataGridView1.Rows[i];
if (row.IsNewRow) break;
decimal product = (decimal)row.Cells[0].Value * (int)row.Cells[1].Value;
sum += product;
row.Cells[2].Value = product;
}

textBox1.Text = sum.ToString();

If there's any chance that some of the rows could contain null values, replace this line:

decimal product = (decimal)row.Cells[0].Value * (int)row.Cells[1].Value;

with this:

decimal product = Convert.ToDecimal(row.Cells[0].Value) * Convert.ToInt32(row.Cells[1].Value);

Zero will then be used for the null values.
Luka Roguljic13y ago
problem is that I have price in one Column(A) and this value is from database and in second Column(B) is amount, so amount user puts manually.

But thank you so much for this so far, ill try to figure it out !!
Vulpes13y ago
Data-binding tends to mess things up.

The best thing to do is to perform the calculations on the rows in your DataTable, adding a new column if necessary, and then bind (or re-bind) to that.
Luka Roguljic13y ago
This code works :) for datadridview that gets values on button click.

I did ask that question, but i thought that it will work with datagridview that gets data from database, should it work ??

This is the case: i have two datagridview, first gatagridview gets data from database. second datagridview gets values after I select row from first datagridview and add that row to second datagridview.

When i apply your code to my project i get this error:

in line >> decimal product = Convert.ToDecimal(row.Cells[1].Value) * Convert.ToInt32(row.Cells[2].Value);

argument out of range exception was unhandled