Problem when summing datagridview selected cells

Irakli Lekishvili

16y2.8kVisual Basic .NET

Hi guys

I to label (tlblPriceTotal) show sum of all selected cells.

I programed this code

But it does not works correctly. when i selecte something this code begin summing from first row

if i select another column it summing same (priceDataGridViewTextBoxColumn)

what is problem can anybody help me?

Thanks.

 private void dataGridView1_SelectionChanged(object sender, EventArgs e)
    {
      decimal nextNumber = 0;
      decimal sumNumbers = 0;

      for (int i = 0; i < dataGridView1.SelectedCells.Count - 1; i++)
      {
        nextNumber = (decimal)dataGridView1.Rows[i].Cells["priceDataGridViewTextBoxColumn"].Value;        
        sumNumbers += nextNumber;
      }

      tlblPriceTotal.Text = "Sum: " + sumNumbers.ToString();
      tlblSelectedCellsTotal.Text = "Total Selected: " + dataGridView1.SelectedCells.Count.ToString();     
    }

2 Replies

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

Sam Hobbs16y ago
Use the debugger to single-step through the code to get a more precise understanding of what is happening. These problems often happen when we assume something that is not true so you need to do something to ensure that everything is working the way you assume they are. You can easily use the debugger to single-step through the code without even changing the program.
Suthish Nair16y ago
i think you need a check for the particular row is selected or not, before your summing logic.
refer article