Thanks for contacting Syncfusion.
We have analyzed your query and we can achieve your requirement by using the below code.
Please refer the following code snippet.
void View_CollectionChanged(object sender, System.Collections.Specialized.NotifyCollectionChangedEventArgs e)
var index = e.NewStartingIndex;
var rowIndex = this.GridDataControl1.Model.ResolvePositionToIndex(index);
var record=e.NewItems as Person;
var records = this.GridDataControl1.Model.View.Records;
var result = from c in records
where (c.Data as Person).No == record.No
if (result.Count() >= 2)
We can get the exact record position by listening the Collection Changed event, even the grid is in sort.
And I have moved the current cell to that new record position by using MoveTo method. If the newly added record contains a unique No means the current cell position moved to the first column,
if it’s a duplicate row, then it moves to the second column.
We have prepared a sample based on your requirement. Please find the sample from the below location.
Please let us know, if you have any queries.
Thanks for your update.
Please let us know if you require further assistance from us.