The ASPxPivotGrid allows a sequence of operations that affect its appearance and/or functionality to be performed without having the control render itself after each modification. To do this, the code performing sequential changes to the ASPxPivotGrid must be enclosed within calls to the ASPxPivotGrid.BeginUpdate and ASPxPivotGrid.EndUpdate methods. This improves performance and avoids unnecessary render operations.
The BeginUpdate method locks the pivot grid control until the ASPxPivotGrid.EndUpdate method is called. Any changes made after a call to the BeginUpdate method don’t force the control to update itself. The ASPxPivotGrid.EndUpdate method invalidates and unlocks the pivot grid so that any further changes are applied immediately.
If the BeginUpdate method has been called several times, the ASPxPivotGrid.EndUpdate method must be called as many times as the BeginUpdate. Otherwise, the control stays locked. To ensure that the ASPxPivotGrid.EndUpdate method is always called even if an exception occurs, wrap any calls to BeginUpdate and ASPxPivotGrid.EndUpdate methods in a try…finally statement.