syncronisation between background datatable and grid

[Catinat Velmourougan]

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

[Administrator]

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();
	}
}

            

[Catinat Velmourougan]

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

[Administrator]

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();

[Administrator]

hi,

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

regards,
catinat

[Administrator]

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