c# datagridview cells multiplications with sum

Question

hi i used code for below datagridview cells sum private void dataGridView1_CellValueChanged(object sender DataGridViewCellEventArgs e) { int sum = 0; for (i = 0; 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

Vulpes · Answer

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 { 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 { 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.

Luv L · Answer

thanks Vulpes sir.

Vithal Wadje · Answer

good answer Vulupes sir

Luv L · Answer

hi anybody solve this problem yaar its too late.nibody havet solution

Luv L · Answer

u r code is okbut 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?

Wim Sturkenboom · Answer

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 { 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 :-)