Data Editors - Combo Box Filtering a Large Data Source


This demo shows how you can filter the data source of a DevExpress ASP.NET Autocomplete Combo Box (ASPxComboBox) editor that contains a large amount of records (approximately 20,000). For this purpose, both the ItemsRequestedByFilterCondition and ItemRequestedByValue events of the editor are handled.

In this demo, the ASPxComboBox does not perform filter operations on the entire database by itself. Instead, all required data processing is delegated to the database server, which returns only small portions of the data to be displayed by the editor.

This technique minimizes the application server's workload, and significantly reduces the application's response time. This technique, together with the 'Contains' filter mode of the ASPxComboBox editor, allows your customers to search against a large amount of data.

When the ASPxComboBox is in incremental filtering mode, it has the capability to start filtering only after an end-user has typed a specific number of symbols in the editor's text box. The FilterMinLength property can be used to define the minimum length of the filter string input. Once the minimum length is met, filtering operations are initiated.

This behavior is extremely useful when the ASPxComboBox works with a large amount of data. In this case, due to the large size of the data set, performing filtration on each symbol typed is inefficient, and may affect application performance. Thus, by delaying the start of filter operations using this minimum length requirement, you can provide end-users with more accurate results, and improve the performance of your page.

Version: v2017 vol 1.5
Copyright © 2006-2017 Developer Express Inc
Your Next Great ASP.NET App Starts Here

Get started today and download your 30-day trial of ASP.NET Controls and Libraries (includes 30 days of free technical support).

All demos ship with full source code and are included in the DevExpress ASP.NET distribution. Refer to the Demos and Sample Applications topic to learn more.

DevExpress ASP.NET Controls and Libraries ship as part of DevExpress Universal, DXperience and ASP.NET Subscriptions and are backed by a 60 day unconditional money-back guarantee.
To learn more and obtain pricing information, visit the Compare Features and Pricing webpage. For immediate assistance, contact us by Email at or by phone at +1 (818) 844-3383 between 7:30am and 4:30pm Pacific Time.