How to auto-change the cell value when another cell's value is changed in the same row?

[Yujin Wu]

Hi Team,

 

I want to realize below feature:

 

1. There are 3 columns in grid which have number-format value; ( column1, column2, column3)

2. When value in column1 or column2 is changed, column3 should change too right now. (column3 = column1 - column2);

3. value-changed row should be got because we will update it into database.

 

Could you modify the code based on my demo. Appreciated for your helps.

 

Thanks,

Yujin

 

Attachment: EditColumnInGridGroupingControl_c24db723.rar

[Yujin Wu]

Hi Team,

 

Any update?

 

Thanks,

Yujin

[Muthukumar Kalyanasundaram]

Hi Yujin,

 

Thank you for your interest in Syncfusion products.

 

If you want to change the row value of column and update the value to datasource, please make use of below code to achieved your scenario.

 

Code:

for (int i = 3; i < this.gridGroupingControl1.TableModel.RowCount; i++) // i = 3 start row index

{

double c5 = (double)this.gridGroupingControl1.TableModel[i, 5].CellValue;

double c6 = (double)this.gridGroupingControl1.TableModel[i, 6].CellValue;

this.gridGroupingControl1.TableModel[i, 7].CellValue = c5 - c6;

}

gridGroupingControl1.DataSource = students;

 

Please let us know if you have any concerns.

 

Regards,

Muthukumar K

Attachment: ColumnTriggerInGridGroupingControl_b0ce1ce6.zip

[Yujin Wu]

Hi Muthukumar,

 

It resolved my issue, appreciated for your support!

 

Thanks,

Yujin

[Solai A L]

Hi Yujin,

 

Thank you for your update.

 

We are glad know that your issue has been resolved. Please let us know if you need any further assistance.

 

 

Thanks & Regards,

AL.Solai.