Where is the CellValueChanged Event Handler for SfDataGrid?

[Hanson]

Hi, 

Where is the CellValueChanged Event Handler for SfDataGrid?

What I want to achieve is to update certain columns of that specific row in an Access database after a change has been made directly in the SfDataGrid. 

I will need to update the [Last Modified Date] of the row if [Name] is changed when directly making a change on the SfDataGrid.

I do not want to update [Last Modified Date] if nothing is changed. That's why I can't use CurrentCellEndEdit.

Any workarounds for this? Thank you so much in advance!

[sulthan]

Even me having the same issues.. no cellvaluechanged event

[Amal Raj U]

Hi Hanson & Sulthan, 

Thanks for using Syncfusion products. 

SfDataGrid doesn’t has CellValueChanged event, instead it supports View.RecordPropertyChanged event that notifies the value changes in a record. 

The value of the specific column can be updated when the value of another column is modified using the ItemPropertiesProvider in View.RecordPropertyChanged event. Please make use of the below example. 

Code example: 

// Wires RecordPropertyChanged event to update "Last Modified Date" 

this.sfDataGrid1.View.RecordPropertyChanged += OnRecordPropertyChanged; 

 

private void OnRecordPropertyChanged(object sender, PropertyChangedEventArgs e) 

{ 

    if (e.PropertyName == "Name") 

    { 

        // Updates the "Last Modified Date" 

        this.sfDataGrid1.View.GetPropertyAccessProvider().SetValue(sender as DataRowView, "Last Modified Date", DateTime.Now); 

    } 

} 

 

Sample location – https://www.syncfusion.com/downloads/support/forum/150657/ze/CS940001786  

 

Regards, 

Amal Raj Umapathy Selvam.