c# datagridview cells multiplications with sum

Luv L

12y2.4k.NET

hi,

i used code for below datagridview cells sum
private void dataGridView1_CellValueChanged(object sender, DataGridViewCellEventArgs e)
{
int sum = 0;
for (i = 0; i < dataGridView1.Rows.Count - 1; i++)
{
if (dataGridView1.Rows[i].Cells[0].Value != null)
{
sum += Convert.ToInt32(dataGridView1.Rows[i].Cells[0].Value.ToString());
label1.Text = Convert.ToString(sum);
}
}
}
}
but i want to below like my cell[0].value sum is shown in label is ok ,but if i can use multipled by any numbers like below image the answer should be = 40
see below details how its come
5+4 = 9 * 2 = 18
(18+2) * 2 = 40

6 Replies

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

Luv L12y ago
thanks Vulpes sir.
0
Vithal Wadje12y ago
good answer Vulupes sir
0
Vulpes12y ago
Well, the following should work for the examples you've given:

private void dataGridView1_CellValueChanged(object sender, DataGridViewCellEventArgs e)
{
int len = dataGridView1.Rows.Count - 1;
int[] val1 = new int[len];
int[] val2 = new int[len];
int[] val3 = new int[len];

for (int i = 0; i < len; i++)
{
object obj1 = dataGridView1.Rows[i].Cells[0].Value;
object obj2 = dataGridView1.Rows[i].Cells[1].Value;
object obj3 = dataGridView1.Rows[i].Cells[2].Value;
val1[i] = (obj1 != null) ? int.Parse(obj1.ToString()) : -1;
val2[i] = (obj2 != null) ? int.Parse(obj2.ToString()) : -1;
val3[i] = (obj3 != null) ? int.Parse(obj3.ToString()) : -1;
}

int sum = 0;
int running = 0;

for (int i = 0; i < len; i++)
{
if (val1[i] > - 1) running += val1[i];

if (val2[i] > -1)
{
running *= val2[i];

if (val3[i] > -1)
{
running *= val3[i];
sum += running;
running = 0;
}
else if (i == len - 1 || val3[i + 1] == -1)
{
sum += running;
running = 0;
}
}
else if (val3[i] > -1)
{
running *= val3[i];
sum += running;
running = 0;
}
else if (i == len -1)
{
sum += running;
}
}

label1.Text = sum.ToString();
}

I've assumed that all values entered in the grid will be non-negative and there will always be exactly 3 columns.

However, I wouldn't like to be sure that this code will always work as I'm not 100% clear what the calculation basis is in all eventualities.

+1
Luv L12y ago
hi,
anybody solve this problem yaar its too late.nibody have,t solution
0
Luv L12y ago
u r code is ok,but sum is repeating the before rows values
plz see below image for ref

correct answer should be 202 but it will come 448
see explaination how it will come
2*2 = 4
(3+4)*2 = 14
((10+4)*3+4)*4 = 184
now total is = 4 + 14 + 184 = 202

plz check?
0
Wim Sturkenboom12y ago
I'm not sure what you're problem is. Can't you multiply?

Also, should the result of your example not be 60?

You can modify the below to suite your needs.

private void dataGridView1_CellValueChanged(object sender, DataGridViewCellEventArgs e)
{
    int sum = 0;
    for (int i = 0; i < dataGridView1.Rows.Count - 1; i++)
    {
        try
        {
            int col0 = dataGridView1.Rows[i].Cells[0].Value == null ? 0 : Convert.ToInt32(dataGridView1.Rows[i].Cells[0].Value.ToString());

            int multiplier =
                dataGridView1.Rows[i].Cells[1].Value != null && !String.IsNullOrWhiteSpace(dataGridView1.Rows[i].Cells[1].Value.ToString()) ?
                Convert.ToInt32(dataGridView1.Rows[i].Cells[1].Value.ToString()) :
                dataGridView1.Rows[i].Cells[2].Value != null && !String.IsNullOrWhiteSpace(dataGridView1.Rows[i].Cells[2].Value.ToString()) ?
                Convert.ToInt32(dataGridView1.Rows[i].Cells[2].Value.ToString()) : 1;

            sum += col0;
            sum *= multiplier;
            label1.Text = Convert.ToString(sum);
        }
        catch (Exception ex)
        {
            label1.Text = ex.Message;
        }
    }
}

This code assumes that either the second or the third column contains a multiplier (but not both). I would normally not use the construction to calculate the multiplier but you might have a hard time explaining it to a teacher in case this is homework :-)
0