Datagridview columns calculations

Question

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.

Hemant Kumar · Answer

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