[Expand]General Information
[Expand]WinForms Controls
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Collapse]WPF Controls
  Prerequisites
 [Expand]What's Installed
 [Expand].NET Core 3 Support
 [Expand]Common Concepts
 [Expand]MVVM Framework
 [Collapse]Controls and Libraries
   Reporting
  [Collapse]Data Grid
   [Expand]Getting Started
   [Expand]Implementation Details
   [Expand]Views
   [Expand]Grid View Data Layout
   [Collapse]Binding to Data
     Binding to Data Overview
     Binding to ICollectionView
     Virtual Source, Server Mode, Instant Feedback Components
    [Expand]Server Mode
    [Collapse]Binding to any Data Source with Virtual Sources
      Virtual Sources Overview
      Infinite and Paged Virtual Sources
      Regular and Async Virtual Sources
      Virtual Sources Limitations
     [Expand]How to Use Virtual Sources
     [Expand]How to Bind to a Custom Service with Restrictions
      How to Bind to IQueryable
      How to Use Skip Tokens to Optimize Paging
      Examples
    [Expand]TreeListView Data Binding
     Applying Data Annotations
     Unbound Columns
     Managing Multi-Thread Data Updates
   [Expand]Master-Detail Data Representation
   [Expand]Data Editing and Validation
   [Expand]Grouping
   [Expand]Filtering and Searching
   [Expand]Sorting
   [Expand]Data Summaries
   [Expand]Paging and Scrolling
   [Expand]Focus, Navigation, Selection
   [Expand]Drag-and-Drop
   [Expand]Conditional Formatting
   [Expand]Appearance Customization
   [Expand]MVVM Enhancements
   [Expand]Printing and Exporting
   [Expand]Miscellaneous
   [Expand]Performance Improvement
   [Expand]Design-Time Features
   [Expand]Visual Elements
   [Expand]End-User Capabilities
   [Expand]Examples
  [Expand]Ribbon, Bars and Menu
  [Expand]Charts Suite
  [Expand]Pivot Grid
  [Expand]Scheduler
  [Expand]Spreadsheet
  [Expand]Rich Text Editor
  [Expand]Tree List
  [Expand]Gauge Controls
  [Expand]Map Control
  [Expand]Layout Management
  [Expand]Windows Modern UI
  [Expand]Printing-Exporting
  [Expand]Data Editors
  [Expand]Navigation Controls
  [Expand]Spell Checker
  [Expand]Property Grid
  [Expand]PDF Viewer
  [Expand]TreeMap Control
  [Expand]Gantt Control
  [Expand]Diagram Control
  [Expand]Windows and Utility Controls
   Dialogs, Notifications and Panels
  [Expand]Scheduler (legacy)
 [Expand]Scaffolding Wizard
 [Expand]Localization
  Redistribution and Deployment
  Get More Help
 [Expand]API Reference
[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)

Virtual Sources Limitations

The GridControl bound to a virtual source only requests top records or a specific page. You can specify which data operations are supported to prevent end users from overloading the database with non-optimal queries. The GridControl hides the UI elements for non-supported operations.

Expanded Sorting

The Sorting feature is disabled by default.

To enable sorting:

Refer to the Add Sorting topic to learn more.

You can sort by single column only initially. Set the GridViewBase.AllowGroupingSortingBySingleColumnOnly property to false to allow sorting by multiple column.

Expanded Filtering

The Filtering feature is disabled by default.

To enable filtering:

Refer to the Add Filtering topic to learn more.

Expanded Searching

The Searching feature is disabled by default. Refer to the Enable Search Panel topic to learn how to enable searching.

Note that virtual sources do not support text highlighting using the Search Panel. This element allows end-users to iterate between found values by pressing F3 or the built-in navigation buttons, which may lead to loading of a huge amount of rows when using virtual sources.

Expanded Total Summaries

The Total Summary feature is disabled by default.

To show summaries:

Refer to the Add Summaries topic to learn more.

Specify the allowed summary types using the ColumnBase.AllowedTotalSummaries and TableView.AllowCountTotalSummary properties to allow end users to display summaries.

Expanded Unbound Columns

If you have to calculate values on server by several columns, specify custom PropertyDescriptors using the VirtualSourceBase.CustomProperties property.

Expanded Conditional Formatting

Expanded Printing and Exporting

Expanded Data Navigator

  • You can use navigation buttons in the Data Navigator. The Remove, Add, Edit buttons are disabled.

Expanded Drag-and-Drop

Expanded Selection

Expanded Best Fit

Expanded Unsupported Features

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