Datagridview columns calculations

Marvin kakuru

Hi all.

I hope your all alright. i am trying to use a datagridview to calculate values.
for example i would like the " column3 values " to Equal " column1 values " multiplied by " column2 values ".

secondly how can i get the SUM of my column3 values and display it in a " textbox1.text "

best regards.

1 Reply

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

Hemant Kumar15y ago

You can do that on CellValidatedEvent and you can apply the same method to RowValidated:

 private void dataGridView_CellValidated(object sender, DataGridViewCellEventArgs e) {                 if (e.RowIndex > -1) {                     DataGridViewRow row = dataGridView.Rows[e.RowIndex];                     string valueA = row.Cells[columnA.Index].Value.ToString();                     string valueB = row.Cells[columnB.Index].Value.ToString();                     int result;                     if (Int32.TryParse(valueA, out result)                         && Int32.TryParse(valueB, out result)) {                         row.Cells[columnTotal.Index].Value = valueA + valueB;                     }                 }             }

You can set column to ReadOnly in the designer, or like this:

dataGridView.Columns["Total"].ReadOnly = true