[Expand]General Information
[Expand]WinForms Controls
[Collapse]ASP.NET Controls and MVC Extensions
 [Expand]Prerequisites
 [Expand]What's Installed
 [Expand]Common Concepts
 [Expand]ASP.NET WebForms Controls
 [Collapse]ASP.NET MVC Extensions
  [Expand]Product Information
  [Expand]Getting Started
  [Expand]Common Concepts
  [Expand]Grid View
  [Expand]Tree List
  [Expand]Card View
   Reporting
  [Expand]Charting
  [Expand]Pivot Grid
  [Expand]Spreadsheet
  [Expand]Rich Text Editor
  [Expand]Scheduler
  [Expand]Site Navigation and Layout
  [Expand]HTML Editor
  [Expand]Vertical Grid
  [Collapse]Data Editors Extensions
    Editor List
    Main Features
   [Collapse]Common Concepts
    [Collapse]Binding Data Editors to Data
      Binding to Large Data (Database Server Mode)
     Getting Editor Values
     Mask Editing
    [Expand]Validation
     Accessibility Support
   [Expand]BinaryImage
   [Expand]Button
   [Expand]ButtonEdit
   [Expand]Calendar
   [Expand]Captcha
   [Expand]CheckBox
   [Expand]CheckBoxList
   [Expand]ColorEdit
   [Expand]ComboBox
   [Expand]DateEdit
   [Expand]DropDownEdit
    Filter Control
   [Expand]GridLookup
   [Expand]HyperLink
   [Expand]Image
   [Expand]Label
   [Expand]ListBox
   [Expand]Memo
   [Expand]ProgressBar
   [Expand]RadioButton
   [Expand]RadioButtonList
   [Expand]SpinEdit
   [Expand]TextBox
   [Expand]TimeEdit
   [Expand]TokenBox
   [Expand]TrackBar
   [Expand]ValidationSummary
   [Expand]Strongly-Typed Editor Types
  [Expand]Docking and Popups
  [Expand]File Management
  [Expand]Data and Image Navigation
  [Expand]Multi-Use Site Extensions
  [Expand]SpellChecker
  [Expand]Query Builder
 [Expand]Localization
 [Expand]Redistribution and Deployment
  Get More Help
 [Expand]API Reference
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Office File API
[Expand]Reporting
[Expand]Report and Dashboard Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]eXpress Persistent Objects
[Expand]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation
View this topic on docs.devexpress.com (Learn more)

Binding to Large Data (Database Server Mode)

The ComboBoxExtension, TokenBoxExtension and ListBoxExtension extensions support the database server mode. In this mode, list editors load only the required (visible) items to the server memory and implement data-aware operations (for example, filtering) at database level.

To enable database server mode, bind list editors to a LinqServerModeDataSource or EntityServerModeDataSource data source (BindToLINQ and BindToEF methods) and use the CallbackRouteValues method. When a user applies a filter to a combo box or list box, the editor loads the filtered data to the server memory and displays this data. You can also use the CustomFiltering property to specify a delegate function to implement custom filtering logic on the server side (when the editor operates in Database Server Mode).

Tip

Refer to the Members Table for a list of the available APIs.

Partial View:

Expanded Online Demo

Refer to Large Database: Server Mode online demo to see this feature in action.

Expanded Member Table

Expanded Database Server Mode Limitations

In database server mode, list editors transform filter expressions (Criteria Language Syntax) to SQL requests. If list editors (in multi-column mode) use the TextFormatString property, the filter expression ignores the "alignment" and "format string" format parameters.

The following table illustrates how the editor converts its format string in regular data binding mode and database server mode:

Regular Data Binding Database Server Mode
"{0:d} from {1,2:n}" "{0} from {1}"

Use the ListEditCustomFilteringEventArgs.FilterExpression property with the delegate the CustomFiltering property specifies to filter list editors items when the format string functionality is applied. Refer to the Members Table for a list of the available APIs.

Is this topic helpful?​​​​​​​