Skip to main content
BuyLog In
WPF Controls
Search in…
Docs > WPF Controls > Controls and Libraries > Pivot Grid > Binding to Data > Items Source Configuration Wizard > ICollectionView Specifics
All docs
V24.2
WPF Controls
Prerequisites
What's New
What's Installed
.NET/.NET Core Support
Common Concepts
MVVM Support
MVVM Framework
Controls and Libraries
Reporting
Data Grid
Ribbon, Bars and Menu
Charts Suite
Pivot Grid
Get Started
Fundamentals
Binding to Data
Binding to Data Overview
Items Source Configuration Wizard
ADO.NET Typed DataSet
Unbound Data Source
Entity Framework
Entity Framework (EF) Core
LINQ to SQL
WCF Data Services
OData V4 Services
XPO Data Source
OLAP Cube
IList and IEnumerable Data Sources
ICollectionView Specifics
In-Memory Mode
OLAP Mode
Database Server Mode
Local Data Stores
Asynchronous Mode
Data Shaping
Data Analysis
Layout
Printing and Exporting
End-User Interaction
Appearance
MVVM Support
UI Elements
End-User Capabilities
Examples
Scheduler
Spreadsheet
Rich Text Editor
Tree List
Gauge Controls
Map Control
Layout Management
Windows Modern UI
Printing-Exporting
Data Editors
Navigation Controls
Spell Checker
Property Grid
PDF Viewer
TreeMap Control
Gantt Control
Diagram Control
Windows and Utility Controls
Dialogs, Notifications and Panels
Office File API
Sankey Diagram Control
Sunburst Control
Heatmap Control
Scheduler (legacy)
AI-powered Extensions
Localization
Security Considerations
Support, Debug, and Troubleshooting
Redistribution and Deployment
Desktop & Web App UI Framework (Powered by EF Core)
Get More Help
API Reference
Download CHM

ICollectionView Specifics

The Items Source Configuration Wizard allows you to use the ICollectionView component to bind the PivotGridControl to various types of data sources. This component enables collections to have the functionalities of current record management, custom sorting, filtering, and grouping.

ItemsSourceConfigurationWizard_ADO_ICollectionView

After you have specified a binding method as Manipulating Data via ICollectionView, click Next. The following settings are available on the final page.

ItemsSourceConfigurationWizard_ADO_ICollectionView_Finish

  • Table - Specify the table from the data source.

  • Collection View Type - Select the type of the CollectionView used for grouping, sorting, filtering, and navigating a data collection. You can choose between the ListCollectionView and BindingListCollectionView. After you have specified the required type, you can perform grouping and sorting using the Group Descriptions and Sort Descriptions options, respectively.

    ItemsSourceConfigurationWizard_ADO_ICollectionView_Settings

  • Culture - Specify the culture to use during sorting.