How to total rows in DGV upon load

Hello I am trying to total the cells of each row in a DGV and add it to a total column upon load. I have an idea on how to do it but I am not sure where to put the code. I know I could do something like

        int val1 = Convert.ToInt32(dataGridView1.Rows[e.RowIndex].Cells[1].Value);
        int val2 = Convert.ToInt32(dataGridView1.Rows[e.RowIndex].Cells[2].Value);
        int val3 = Convert.ToInt32(dataGridView1.Rows[e.RowIndex].Cells[3].Value);
        int val4 = Convert.ToInt32(dataGridView1.Rows[e.RowIndex].Cells[4].Value);

        int val5 = Convert.ToInt32(dataGridView1.Rows[e.RowIndex].Cells[5].Value);
        int val6 = Convert.ToInt32(dataGridView1.Rows[e.RowIndex].Cells[6].Value);
        int val7 = Convert.ToInt32(dataGridView1.Rows[e.RowIndex].Cells[7].Value);
        int va开发者_运维问答l8 = Convert.ToInt32(dataGridView1.Rows[e.RowIndex].Cells[8].Value);

        dataGridView1.Rows[e.RowIndex].Cells[9].Value = (val1 + val2 + val3 + val4) - (val5 + val6 + val7 + val8);

But the issue with that it seems is I have to use an event to trigger the calculation.

Any help on this matter would be appreciated.

Kor

If you're using data binding you can set your row totals in the DataGridView's DataBindingComplete event.

The code you provided looks like it will update the totals column but let's refactor it a bit so you can use it in more than one place:

private void ComputeAndDisplayRowTotal(int rowIndex) {
    int val1 = Convert.ToInt32(dataGridView1.Rows[rowIndex].Cells[1].Value);
    int val2 = Convert.ToInt32(dataGridView1.Rows[rowIndex].Cells[2].Value);
    int val3 = Convert.ToInt32(dataGridView1.Rows[rowIndex].Cells[3].Value);
    int val4 = Convert.ToInt32(dataGridView1.Rows[rowIndex].Cells[4].Value);
    int val5 = Convert.ToInt32(dataGridView1.Rows[rowIndex].Cells[5].Value);
    int val6 = Convert.ToInt32(dataGridView1.Rows[rowIndex].Cells[6].Value);
    int val7 = Convert.ToInt32(dataGridView1.Rows[rowIndex].Cells[7].Value);
    int val8 = Convert.ToInt32(dataGridView1.Rows[rowIndex].Cells[8].Value);

    dataGridView1.Rows[e.RowIndex].Cells[9].Value = (val1 + val2 + val3 + val4) - (val5 + val6 + val7 + val8);
}

Call this method in your DataBindingComplete event like this:

private void dataGridView1_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e) {
    foreach (DataGridViewRow row in dataGridView1.Rows) {
        // Don't want to update the total column on the new row at the bottom of the DGV.
        if (!row.IsNewRow) {
            ComputeAndDisplayRowTotal(row.Index);
        }
    }
}

Now if you allow the user to edit a cell you can update the row's totals column using the CellEdnEdit event, like this:

private void dataGridView1_CellEndEdit(object sender, DataGridViewCellEventArgs e) {
    ComputeAndDisplayRowTotal(e.RowIndex);
}