[Expand]General Information
[Collapse]WinForms Controls
  Prerequisites
 [Expand]What's Installed
 [Expand]Build an Application
 [Collapse]Controls and Libraries
  [Expand]Forms and User Controls
  [Expand]Messages, Notifications, and Dialogs
  [Expand]Editors and Simple Controls
  [Expand]Ribbon, Bars and Menu
  [Expand]Application UI Manager
  [Expand]Docking Library
  [Expand]Data Grid
  [Expand]Vertical Grid
  [Expand]Property Grid
  [Collapse]Pivot Grid
   [Expand]Getting Started
   [Expand]Fundamentals
   [Expand]Binding to Data
   [Expand]Data Shaping
   [Expand]Data Analysis
   [Expand]Layout
   [Expand]Focus and Navigation
   [Expand]Printing and Exporting
   [Expand]Appearance
   [Expand]Design-Time Features
   [Expand]Miscellaneous
   [Expand]UI Elements
   [Expand]End-User Capabilities
   [Collapse]Examples
    [Expand]Providing Data
    [Expand]Summarization
    [Expand]Sorting
    [Expand]Grouping
    [Expand]Filtering
    [Collapse]Drill-Down (Underlying Data)
      How to: Display Underlying Records
      How to: Create the Underlying Data Source (Drill-Down) in an Asynchronous Operation
    [Expand]Editing
    [Expand]Layout Features
    [Expand]Formatting
    [Expand]Data Output
    [Expand]Appearance
    [Expand]Miscellaneous
  [Expand]Member Tables
  [Expand]Tree List
  [Expand]Chart Control
  [Expand]Diagrams
  [Expand]Gauges
  [Expand]Map Control
  [Expand]Scheduler
  [Expand]Spreadsheet
  [Expand]Rich Text Editor
  [Expand]Spell Checker
  [Expand]Form Layout Managers
  [Expand]Navigation Controls
  [Expand]Printing-Exporting
  [Expand]PDF Viewer
   Reporting
  [Expand]Snap
  [Expand]TreeMap Control
  [Expand]Sunburst Control
 [Expand]Common Features
  Get More Help
 [Expand]API Reference
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Office File API
[Expand]Reporting
[Expand]Report and Dashboard Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]eXpress Persistent Objects
[Expand]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation
View this topic on docs.devexpress.com (Learn more)

How to: Create the Underlying Data Source (Drill-Down) in an Asynchronous Operation

This example performs an asynchronous operation that creates a drill-down data source for the selected PivotGrid cell and gets the operation result - the underlying data source.

In this example, the PivotGrid control is bound to the LinqServerModeSource (see LinqServerModeSource) data source and operates in server mode.

The PivotGridControl.CellClick event handler calls the PivotGridControl.CreateDrillDownDataSourceAsync method to generate a drill-down data source for the selected cell. The method parameter specifies the number of records to return. The method also specifies the columns to add to the the data set.

The last item in the method's parameter list is the AsyncCompletedHandler (see AsyncCompletedHandler) delegate. The delegate is executed when the operation is complete. The delegate's <i>result</i> parameter is the AsyncOperationResult (see AsyncOperationResult) instance whose Value (see AsyncOperationResult.Value) property contains the result of the operation.

The operation's result is cast to the PivotDrillDownDataSource (see PivotDrillDownDataSource) and the GridControl (see GridControl) displays the underlying records in the auxiliary DrillDown form.

Note

The complete sample project How to Create the Underlying Data Source (Drill-Down) in an Asynchronous Operation is available in the DevExpress Examples repository.

Is this topic helpful?​​​​​​​