Looping through datagridview column cell

Sameer Farooqui

I want to perform addition of the total cell. however, it is giving value of latest cell added. Attached the screenshot of gridview:

Gridview

private void dataGridView1_CellValueChanged_1(object sender, DataGridViewCellEventArgs e)
{

if (dataGridView1["Total", e.RowIndex].Value != null)

{

for (int i =0; i < dataGridView1.Rows.Count; i++)
{
double grandtotal = Convert.ToDouble(dataGridView1["Total", e.RowIndex].Value);
txtboxGrandTotal.Text = grandtotal.ToString();
}
}

}

2 Replies

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

Amit Mohanty4y ago
Accepted answer
Try this
private void dataGridView1_CellValueChanged_1(object sender, DataGridViewCellEventArgs e)
{
    if (dataGridView1["Total", e.RowIndex].Value != null)
    {
        double grandtotal = 0;
        for (int i =0; i < dataGridView1.Rows.Count; i++)
        {
            grandtotal = grandtotal  + Convert.ToDouble(dataGridView1["Total", i].Value);
        }
        txtboxGrandTotal.Text = grandtotal.ToString();
     }
}
Rajanikant Hawaldar4y ago
1. private void dataGridView1_CellValueChanged_1(object sender, DataGridViewCellEventArgs e)
2. {
3. if (dataGridView1["Total", e.RowIndex].Value != null)
4. {
5. for (int i =0; i < dataGridView1.Rows.Count; i++)
6. {
7. double grandtotal = Convert.ToDouble(dataGridView1["Total", i].Value);
8. txtboxGrandTotal.Text = grandtotal.ToString();
9. }
10. }
11. }