PivotFileDataSource Class

The pivot grid control’s data, loaded from a file or stream.

Namespace: DevExpress.Data.PivotGrid

Assembly: DevExpress.PivotGrid.v24.2.Core.dll

Declaration

C#

public class PivotFileDataSource :
    ITypedList,
    IList,
    ICollection,
    IEnumerable

VB.NET

Public Class PivotFileDataSource
    Implements ITypedList,
               IList,
               ICollection,
               IEnumerable

Remarks

The pivot grid control’s data, along with the full layout can be saved to a file or stream via the PivotGridControl.SavePivotGridToFile and PivotGridControl.SavePivotGridToStream methods, respectively. The PivotFileDataSource objects are used to restore the data together with the layout, and load it to the same or another pivot grid control.

To restore the data and layout, create a PivotFileDataSource object, passing the file or stream that contains pivot grid data to the constructor, and assign the created object to pivot grid’s PivotGridControl.DataSource property.

Note

The PivotFileDataSource is a read-only data source.

Example

The following example shows how to save the Pivot Grid Control’s data to a file, and then load it later.

To save the data the PivotGridControl.SavePivotGridToFile method is called. To restore the data, a PivotFileDataSource object is initialized and assigned to the PivotGridControl.DataSource property.

C#

using DevExpress.Data.PivotGrid;

string filePath = "c:\\pivotData.dat";
// Save the control's data to the file.
pivotGridControl1.SavePivotGridToFile(filePath);

//...

// Restore the saved data
PivotFileDataSource ds = new PivotFileDataSource(filePath);
pivotGridControl1.DataSource = ds;

VB.NET

Imports DevExpress.Data.PivotGrid

Dim filePath As String = "c:\\pivotData.dat"
' Save the control's data to the file.
pivotGridControl1.SavePivotGridToFile(filePath)

'...

' Restore the saved data
Dim ds As PivotFileDataSource = New PivotFileDataSource(filePath)
pivotGridControl1.DataSource = ds

Inheritance

Object

PivotFileDataSource