How to refresh the data in grid while updating a record in underlaying Data Table ?

Problem

By default, GridGroupingControl, the data will be reflected as it is in datasource. If any record or cell value is changed in underlying datasource, it will not be reflected in grid immediately.

Solution

In order to update the record while updating the values in underlying datasource, the underlying datasource has to be refreshed while updating the data. Here is the sample which explains the updating the datasource (DataTable). For DataTable, AcceptChanges() method is used to refresh the data.

C#

VB

Screensots

Before

After

Sample:

C# : Refresh_CS

VB : Refresh_VB