Virtual Sources Limitations

  • 3 min to read

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.

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.

Filtering

The Filtering feature is disabled by default.

To enable filtering:

Refer to the Add Filtering topic to learn more.

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.

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.

Unbound Columns

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

Conditional Formatting

Printing and Exporting

Data Navigator

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

Drag-and-Drop

Selection

Best Fit

Unsupported Features