Serializing & Deserializing Pivot Grid for WinForms | Syncfusion Blogs
Live Chat Icon For mobile
Live Chat Icon
Popular Categories.NET  (173).NET Core  (29).NET MAUI  (203)Angular  (107)ASP.NET  (51)ASP.NET Core  (82)ASP.NET MVC  (89)Azure  (40)Black Friday Deal  (1)Blazor  (211)BoldSign  (13)DocIO  (24)Essential JS 2  (106)Essential Studio  (200)File Formats  (65)Flutter  (132)JavaScript  (219)Microsoft  (118)PDF  (81)Python  (1)React  (98)Streamlit  (1)Succinctly series  (131)Syncfusion  (897)TypeScript  (33)Uno Platform  (3)UWP  (4)Vue  (45)Webinar  (50)Windows Forms  (61)WinUI  (68)WPF  (157)Xamarin  (161)XlsIO  (35)Other CategoriesBarcode  (5)BI  (29)Bold BI  (8)Bold Reports  (2)Build conference  (8)Business intelligence  (55)Button  (4)C#  (146)Chart  (127)Cloud  (15)Company  (443)Dashboard  (8)Data Science  (3)Data Validation  (8)DataGrid  (63)Development  (618)Doc  (8)DockingManager  (1)eBook  (99)Enterprise  (22)Entity Framework  (5)Essential Tools  (14)Excel  (39)Extensions  (22)File Manager  (6)Gantt  (18)Gauge  (12)Git  (5)Grid  (31)HTML  (13)Installer  (2)Knockout  (2)Language  (1)LINQPad  (1)Linux  (2)M-Commerce  (1)Metro Studio  (11)Mobile  (501)Mobile MVC  (9)OLAP server  (1)Open source  (1)Orubase  (12)Partners  (21)PDF viewer  (42)Performance  (12)PHP  (2)PivotGrid  (4)Predictive Analytics  (6)Report Server  (3)Reporting  (10)Reporting / Back Office  (11)Rich Text Editor  (12)Road Map  (12)Scheduler  (52)Security  (3)SfDataGrid  (9)Silverlight  (21)Sneak Peek  (31)Solution Services  (4)Spreadsheet  (11)SQL  (10)Stock Chart  (1)Surface  (4)Tablets  (5)Theme  (12)Tips and Tricks  (112)UI  (381)Uncategorized  (68)Unix  (2)User interface  (68)Visual State Manager  (2)Visual Studio  (31)Visual Studio Code  (17)Web  (582)What's new  (323)Windows 8  (19)Windows App  (2)Windows Phone  (15)Windows Phone 7  (9)WinRT  (26)

Serializing & Deserializing Pivot Grid for WinForms

With the upcoming Essential Studio 2018 Volume 2 release, the serialization and deserialization support will be included in the pivot grid control for WPF. This feature provides extensible support for saving the control’s settings as a stream or as an XML document, and it can be loaded whenever needed. Using this support, pivot grid settings like pivot row items, pivot column items, pivot calculation items, filtered items, sorted items, grouping bar items, conditional format settings, and expand/collapse state of pivot items can be limited with the help of built-in customization options while saving and loading the reports.

Serializing Pivot Grid

The pivot grid control allows the user to save its current settings into a stream or XML document using predefined methods. Let’s see what approaches are available for serializing the control in the immediate sections.

Serialize using save file dialog

Using the Serialize() method, the settings of the pivot grid control can be saved to a desired XML document, and its location can be chosen using save file dialog.

this.pivotGridControl1.Serialize();

Serialize using specific file

Using the Serialize(string filename) method, the settings of the pivot grid control can be saved to a document that is specified using its file name.

this.pivotGridControl1.Serialize("PivotGrid.xml");

Serialize using stream

Using the Serialize(Stream stream) method, the settings of the pivot grid control can be saved to the specified stream.

using (FileStream fileStream = File.Create("PivotGrid.xml"))
{
    this.pivotGridControl1.Serialize(fileStream);
}

Serialize to XML string

Using the SerializeToXml() method, the settings of the pivot grid control can be converted to an XML string which can be preserved for later use.

this.pivotGridControl1.SerializeToXml();

Customizing serialization

By default, all the settings of the pivot grid control are serialized to save in the stream format. Instead of requiring that all settings of the control be saved, a few settings can be saved without considering the others. For example, if the grouping bar’s settings are not preferred to save, then the property “SerializeGrouping” of “SerializationOptions” can be set as false to ignore this during serialization, as illustrated in the following code sample.

using (var file = File.Create("PivotGrid.xml"))
{
    SerializationOptions options = new SerializationOptions();
    options.SerializeGrouping = false;
    this.pivotGridControl1.Serialize(file, options);
}

The following chart lists the properties that can be used to ignore required settings during serialization.

PropertyUsage
SerializeSortingTo specify whether sorted items need to be serialized or not.
SerializeFilteringTo specify whether filtered items need to be serialized or not.
SerializeGroupingTo specify whether grouping bar need to be serialized or not.
SerializePivotRowsTo specify whether pivot row items need to be serialized or not.
SerializePivotColumnsTo specify whether pivot column items need to be serialized or not.
SerializePivotCalculationsTo specify whether pivot calculation items need to be serialized or not.
SerializeConditionalFormatsTo specify whether conditional formats need to be serialized or not.
SerializeExpandCollapseStateTo specify whether expand and collapse states need to be serialized or not.

Deserializing Pivot Grid

The pivot grid control allows loading saved settings using predefined methods. Let’s see what approaches are available for deserializing the control in the immediate sections.

Deserialize using open file dialog

Using the Deserialize() method, the settings of the pivot grid control can be restored by selecting the previously saved XML document using the open file dialog.

this.pivotGridControl1.Deserialize();

Deserialize using specific file

Using the Deserialize(string filename) method, the settings of the pivot grid control can be loaded from the specified XML document.

this.pivotGridControl1.Deserialize("PivotGrid.xml");

Deserialize using stream

Using the Deserialize(Stream stream) method, the settings of the pivot grid control can be loaded from the specified file stream.

using (FileStream fileStream = File.OpenRead("PivotGrid.xml"))
{
    this.pivotGridControl1.Deserialize(fileStream);
}

Deserialize from XML string

Using the DeserializeFromXml(string xmlString) method, the control settings stored in the XML string can be loaded into the pivot grid contol.

this.pivotGridControl1.DeserializeFromXml(xmlString);

Customizing deserialization

By default, all settings available in the stream are loaded into the pivot grid control. But the desired settings alone can be loaded by ignoring the rest settings. For example, if the grouping bar’s settings are not desired to load in the pivot grid control, then the property “DeserializeGrouping” of “DeserializationOptions” must be set as false to ignore it during deserialization, as illustrated in the following code sample.

using (FileStream fileStream = File.OpenRead("PivotGrid.xml"))
{
    Deserialization­­­­Options options = new DeserializationOptions();
    options.DeserializeGrouping = false;
    this.pivotGridControl1.Deserialize(fileStream, options);
}

The following are the properties that can be used to ignore required settings during deserialization.

PropertyUsage
DeserializeSortingTo specify whether sorted items need to be serialized or not.
DeserializeFilteringTo specify whether filtered items need to be serialized or not.
DeserializeGroupingTo specify whether grouping bar need to be serialized or not.
DeserializePivotRowsTo specify whether pivot row items need to be serialized or not.
DeserializePivotColumnsTo specify whether pivot column items need to be serialized or not.
DeserializePivotCalculationsTo specify whether pivot calculation items need to be serialized or not.
DeserializeConditionalFormatsTo specify whether conditional formats need to be serialized or not.
SerializeExpandCollapseStateTo specify whether expand and collapse states need to be serialized or not.

Serialization and deserialization result in storage and usage of reports anywhere, at any time. In addition to this, the customization options would reduce the amount of serialized and deserialized data during the storage and retrieval process, thus optimizing the performance.

Reference

A sample has been created to demonstrate the serialization and deserialization support in the pivot grid control by customizing its options. Please try the sample and let us know what you think through the comments below.

Tags:

Share this post:

Popular Now

Be the first to get updates

Subscribe RSS feed

Be the first to get updates

Subscribe RSS feed