devexpress-examples / how-to-obtain-underlying-data-e2173

This example demonstrates how to obtain the records from the control's underlying data source for a particular cell.

Pivot Grid for WPF - How to Display Underlying (Drill-Down) Records

This example demonstrates how to obtain the records from the control's underlying data source for a particular cell. Double-click a cell to invoke a form that contains a grid to show the underlying data.

This example is based on the DevExpress MVVM Framework. When a user double-clicks a cell, the EventToCommand class invokes the bound ShowDrillDownDataCommand defined in the ViewModel.

To pass the event data as a parameter to the command, the EventToCommand.PassEventArgsToCommand property is set to true. The EventArgsToCellInfoConverter instance is assigned to the EventToCommand.EventArgsConverter property to convert the event data to the CellInfo parameter type required for the command.

The command calls the DialogService.ShowDialog method to invoke a custom window that displays the underlying data. The DialogService is a part of the DevExpress MVVM Framework. It is defined in XAML and specifies the DXDialogWindow that contains the GridControl bound to the CellInfo.DrillDownDataSource property.

You can also use the following methods to get the underlying data:

• CellInfo.CreateDrillDownDataSource that returns the collection of records in the original data source with the IEnumerable interface.
• The PivotGridControl.CreateDrillDownDataSource method and CreateDrillDownDataSource methods available in PivotGridControl event handlers return the PivotDrillDownDataSource object.

Asynchronous drill-down operations are performed with the following methods:

• CellInfo.CreateDrillDownDataSourceAsync
• PivotGridControl.CreateDrillDownDataSourceAsync

Files to Look At

• MainWindow.xaml (VB: MainWindow.xaml)
• MainWindow.xaml.cs (VB: MainWindow.xaml.vb)
• ViewModel.cs (VB: ViewModel.vb)

Documentation

• Drill-Down to the Underlying Data
• Asynchronous Mode

More Examples

• How to Use CreateDrillDownDataSource Methods to Display Underlying (Drill-Down) Data