PivotGridControl.RefreshData() Method

Reloads data from the control’s data source and recalculates summaries.

Namespace: DevExpress.XtraPivotGrid

Assembly: DevExpress.XtraPivotGrid.v24.1.dll

NuGet Package: DevExpress.Win.PivotGrid

Declaration

C#

public void RefreshData()

VB.NET

Public Sub RefreshData

Remarks

This method reloads data from the control’s data source specified by the PivotGridControl.DataSource and PivotGridControl.DataMember properties. This causes the summaries to be recalculated against the data fields.

When the control’s data source is modified, the Pivot Grid Control does not automatically reload the records. In this case, the RefreshData method can be called to force the data to reload.

To reload data asynchronously, use the PivotGridControl.RefreshDataAsync method.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the RefreshData() method.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

winforms-highlight-pivot-cells-that-correspond-to-a-series-point-on-hover/CS/WindowsApplication53/Form1.cs#L22

PopulateTable();
pivotGridControl1.RefreshData();
pivotGridControl1.BestFit();

winforms-pivot-customize-appearance-of-the-even-odd-groups-of-cells/CS/WindowsApplication53/Form1.cs#L17

PopulateTable();
pivotGridControl1.RefreshData();
pivotGridControl1.BestFit();

winforms-pivot-grid-differentiate-between-null-and-zero-values/CS/WindowsApplication53/Form1.cs#L20

PopulateTable();
pivotGridControl1.RefreshData();
pivotGridControl1.BestFit();

pivot-grid-winforms-provide-custom-date-time-group-intervals-and-preserve-correct-sort-order/CS/WindowsApplication21/Form1.cs#L39

FillDataSource(DateTime.Today.AddYears(-2), DateTime.Today.AddYears(2));
pivotGridControl1.RefreshData();
pivotGridControl1.BestFit();

winforms-pivot-chart-integration-hide-unnecessary-series-from-the-chart/CS/WindowsApplication53/Form1.cs#L12

PopulateTable();
pivotGridControl1.RefreshData();
pivotGridControl1.BestFit();

VB.NET

winforms-highlight-pivot-cells-that-correspond-to-a-series-point-on-hover/VB/WindowsApplication53/Form1.vb#L20

PopulateTable()
pivotGridControl1.RefreshData()
pivotGridControl1.BestFit()

winforms-pivot-customize-appearance-of-the-even-odd-groups-of-cells/VB/WindowsApplication53/Form1.vb#L20

PopulateTable()
pivotGridControl1.RefreshData()
pivotGridControl1.BestFit()

winforms-pivot-grid-differentiate-between-null-and-zero-values/VB/WindowsApplication53/Form1.vb#L18

PopulateTable()
pivotGridControl1.RefreshData()
pivotGridControl1.BestFit()

pivot-grid-winforms-provide-custom-date-time-group-intervals-and-preserve-correct-sort-order/VB/WindowsApplication21/Form1.vb#L34

FillDataSource(Date.Today.AddYears(-2), Date.Today.AddYears(2))
pivotGridControl1.RefreshData()
pivotGridControl1.BestFit()

winforms-pivot-chart-integration-hide-unnecessary-series-from-the-chart/VB/WindowsApplication53/Form1.vb#L16

PopulateTable()
pivotGridControl1.RefreshData()
pivotGridControl1.BestFit()