We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

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

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

4 Replies

YW Yujin Wu February 13, 2015 07:58 AM UTC

Hi Team,
 
Any update?
 
Thanks,
Yujin


MK Muthukumar Kalyanasundaram Syncfusion Team February 14, 2015 05:04 AM UTC

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


YW Yujin Wu March 10, 2015 05:23 AM UTC

Hi Muthukumar,
 
It resolved my issue, appreciated for your support!
 
Thanks,
Yujin


SA Solai A L Syncfusion Team March 11, 2015 08:05 PM UTC

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.

 

 


Loader.
Up arrow icon