Free Trial Buy Now

Combo Box - Filtering Large Data Source

v
FilterMinLength:  
+
-

Description

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

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

This technique minimizes the application server's workload, and significantly reduces the application's response time. Using this technique, together with the 'Contains' filter mode of the ASPxComboBox editor allows you to deliver to your customers the ability for a fast and efficient search against a huge amount of data.

Being in incremental filtering mode, the ASPxComboBox has a 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 for the filter string input, after which filtering operations are initiated.

This behavior is extremely useful when the ASPxComboBox works with a large amount of data. In this case, performing filtration on each new symbol typed is not sensible, due to the large size of the resulting data set, which might affect the application performance. Thus, pausing the start of filter operations allows you to provide end-users with more sensible results, and to improve the performance of your page.

Version: v2012 vol 2.8
Experience the DevExpress Difference Today
Demos with source code are included with an installation of DevExpress controls for ASP.NET. Refer to the Demos and Sample Applications topic to learn more.
To download your free evaluation copy of our award-winning ASP.NET libraries, visit the Downloads page
All DevExpress ASP.NET Controls ship as part of DXperience ASP.NET, Enterprise, and Universal.
To obtain pricing information, visit the Pricing Options page or contact us via Email at info@devexpress.com
or by telephone at +1 (818) 844-3383 between 8:30am and 5pm Pacific Time.