Show theme settings Shopping cart Download trialFree Trial
Change Theme Settings
Change Theme Settings
Show All Themes

Incremental Filtering


The DevExpress Grid Lookup (ASPxGridLookup) editor combines the functionality of ASPxGridView and ASPxDropDownEdit, to allow an end-user to select items from a drop-down grid. ASPxGridLookup also supports the server mode functionality of ASPxGridView, which allows the editor to work efficiently with large data sources by loading data in small portions, on demand. To work in server mode, the editor must be bound to a data source of the XpoDataSource or LinqServerModeDataSource type.

The Grid Lookup editor enables end-users to filter list items dynamically, based on the text typed into the editor's input box on the client side (“find-as-you-type” filtering). The following filter modes are available, which are controlled by the IncrementalFilteringMode property:

  • Contains - The editor is filtered for list items that contain the search string. The search string matches are highlighted.
  • StartsWith - The editor is filtered for list items that begin with the search string. The editor value is autocompleted with the first corresponding value.
  • None - Filtering is not applied to list items.

The value typed in the edit box by an end-user is searched for within the editor's item list, based on the defined format of the TextFormatString property.

In this demo, the Filter Row option allows you to hide the incremental filter and display a grid filter row that allows end-users to filter the grid data by a specific column.

Local Copy of this Demo
To inspect the source code for this demo on your machine, you must first install our components via the DevExpress Component Installer.
You can open a local copy of this online demo directly from this webpage (if using v20.2.8, 21.1.4 or higher).
Open CS Solution
Open VB Solution
The source code files for this demo are installed (by default) in the following directories:
\Users\Public\Documents\DevExpress Demos XX.X\Components\ASP.NET\CS\ASPxGridViewDemos
\Users\Public\Documents\DevExpress Demos XX.X\Components\ASP.NET\VB\ASPxGridViewDemos