Losing update on Parent Row

[Theo Danzfuss]

I have a Grid where only ONE parent record is allowed to be expanded at a time. To enforce this I call Table.CollapseAllRecords in my RecordExpanding event handler.
This seems to work fine except in the following scenario. When a User edits the parent Record I expand the Record out of code - this causes the RecordExpanding event to fire and close other open rows, BUT I lose the update on the parent row. The value still appears in the grid, but not in the underlying DataTable?

Is there any other way I can enforce Only one expanded row at a time? Calling Collapse in the Expanding event seems Counterproductive?

Regards.
TD

[Administrator]

Instead of calling Table.CollapseAllRecords, you can just have a variable that tracks the opened record. Then you could just call Collapse on that single record instead of resetting the entire table. Does this make a difference in the problem you are seeing?

[Administrator]

Another thing you could try is to call

this.gridGroupingControl1.CurrencyManager.EndCurrentEdit();

before you collapse anything to see if that will avoid the problem as well.