Change Theme Settings
Change Theme Settings
Themes
 
Show All Themes
v
...v

Large Database (Server Mode)

v
Customer Details
First Name:
Last Name:
Phone:
Time to retrieve the last data: ... ms

The ASPxComboBox control supports the database Server mode when the editor is bound to the built-in EntityServerModeDataSource or LinqServerModeDataSource data providing components. These data sources automatically create requests to a data table and load only required data to the server memory.

In Server mode, the combo box can bind to large datasets which should not be loaded to the server memory on each request (like in case of other data sources).

To enable the database server mode, bind a combo box to a EntityServerModeDataSource or LinqServerModeDataSource data providing component and set the EnableCallbackMode property to true. The CallBackPageSize property allows you to control the number of records loaded on the client on each request. In this case, the control sends a callback to the server when a user scrolls or filters the editor.

Note that the server-mode data sources (LinqServerModeDataSource or EntityServerModeDataSource) generate SQL requests automatically. Refer to the Custom Data Binding demo that illustrates how to implement a custom data loading logic.

Collapse/Expand
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\ASPxEditorsDemos
\Users\Public\Documents\DevExpress Demos XX.X\Components\ASP.NET\VB\ASPxEditorsDemos