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.