syncronisation between background datatable and grid

hi, I have a grid grouping control. I have background datatable as the datasource. I am currently focussed on a cell.I change a value and move to another cell in the same row. I have a method call on my record value changed even that gets the new value , applies calculation procedures and update values to other columns ,based on the new value, on the record.I update to teh background datatable.I dont want to update the grid directly.The issue is I see the changes only when I move to the next row and not to the next column on the same row. How to see the changes made to the background datatable when I move to the next column? In general, How to push changes from the grid to the datatable? and How to push changes from the background table to the grid manually whenever I want them? regards, catinat

Try handling the TableControlCurrentCellMoved event.

private void gridGroupingControl1_TableControlCurrentCellMoved(object sender, GridTableControlCurrentCellMovedEventArgs e)
{
	GridCurrentCell cc = e.TableControl.CurrentCell;
	if(cc.MoveFromRowIndex != cc.MoveToRowIndex)
	{
		this.gridGroupingControl1.Table.CurrentRecord.EndEdit();
	}
}
 

hi, In general, How to push changes from the grid to the datatable? and How to push changes from the background table to the grid manually whenever I want them? regards, catinat

In either case, I think calling EndCurrentEdit on the currency manager should do it. CurrencyManager cm = this.BindingContext[this.gridGroupingControl1.DataSource, this.gridGroupingControl1.DataMember] as CurrencyManager; cm.EndCurrentEdit();

hi, Whenever I call the SyncfusionGridControl.CurrencyManager.EndCurrentEdit(); my scrolling becomes slow. Any reason as why this happens? regards, catinat

hi, We discovered that its not endcurrentedit but setvalue which is causing the issue. Any clues? regards, catinat