Log In
[Expand]General Information
[Collapse]WinForms Controls
 [Expand]What's Installed
 [Expand]Build an Application
 [Collapse]Controls and Libraries
  [Expand]Forms and User Controls
  [Expand]Messages, Notifications and Dialogs
  [Expand]Editors and Simple Controls
  [Expand]Ribbon, Bars and Menu
  [Expand]Application UI Manager
  [Expand]Docking Library
  [Collapse]Data Grid
   [Expand]Getting Started
   [Collapse]Binding to Data
    [Collapse]Server Mode
      Regular Binding Mode vs Regular Server Mode vs Instant Feedback Mode
      Grid Features Supported in Server Mode
      Server Mode Limitations
      Data Stores Supported in Server Mode When Using XPO
      Server Mode: Binding to a Data Source Using eXpress Persistent Objects
      Instant Feedback Mode
      Tutorial: Large Data Sources and Instant Feedback with Server Mode
     Grid Control Binding Specifics
     Posting Data to a Connected Database
     Unbound Columns
     Binding to Entity Framework Models
     Binding via Data Source Configuration Wizard
     Fluent API Support
     Member Table: Data Binding
     Tutorial: ADO.NET Data
     Tutorial: Create and Manage Columns at Design Time
     Tutorial: Create and Manage Data in Code and Apply Data Annotation Attributes
     Tutorial: Entity Framework Data
     Tutorial: Unbound Columns
     Tutorial: Working with Columns in Code
   [Expand]Grid View
   [Expand]View Technology
   [Expand]Data Editing
   [Expand]Filtering and Locating Rows
   [Expand]Focus and Selection Handling
   [Expand]Processing Rows
   [Expand]Formatting Cell Values
   [Expand]Master-Detail Relationships
   [Expand]Asynchronous Image Load
   [Expand]Export and Printing
   [Expand]Appearance and Conditional Formatting
   [Expand]Batch Modifications
   [Expand]Hit Information
   [Expand]Popup Menus
   [Expand]Saving and Restoring Layouts
   [Expand]Visual Elements
   [Expand]Design-Time Features
   [Expand]End-User Capabilities
    Included Components
  [Expand]Vertical Grid
  [Expand]Pivot Grid
  [Expand]Tree List
  [Expand]Chart Control
  [Expand]Map Control
  [Expand]Rich Text Editor
  [Expand]Spell Checker
  [Expand]Form Layout Managers
  [Expand]Navigation Controls
  [Expand]PDF Viewer
  [Expand]TreeMap Control
 [Expand]Common Features
  Get More Help
 [Expand]API Reference
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Document Server
[Expand]Report Server
[Expand]eXpressApp Framework
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

Server Mode: Binding to a Data Source Using eXpress Persistent Objects

To enable a server mode (regular or Instant Feedback) you need to create an appropriate data source. You can use data sources provided by the eXpress Persistent Objects (XPO) library or use dedicated data sources tailored to work with 'LINQ to SQL Classes'. This topic shows how to use data sources provided by the XPO library.

In this topic, the term grid control refers to a data-aware control that supports a server mode.

Expanded Server Mode: Binding to a Data Source Using eXpress Persistent Objects

To implement a server mode using data sources provided by the eXpress Persistent Objects (XPO) library, you should do the following.

  • Create an XPServerCollectionSource or XPInstantFeedbackSource object. At design time, you can find these components in the Toolbox and add them to the form.

    If you need to use the regular (synchronous) server mode, use the XPServerCollectionSource component. To use the Instant Feedback (asynchronous) mode, use the XPInstantFeedbackSource component. See the Server Mode to learn more.

  • Provide descriptive information on the target data.
  • Assign the created data source to the grid control's DataSource property.
  • Provide connection settings to the target data store.

In a server mode, a target data table must contain a key field. If the table doesn't contain a key field, it cannot be used as a data source in a server mode.

Expanded Providing Descriptive Information on the Target Data

When working with XPO, you need to provide descriptive information on the target data for a server mode data source you are using. To accomplish this, use one of the following approaches.

Expanded Providing Connection Settings

You need to provide connection settings to enable XPO to connect to a required data store. There are multiple methods to provide connection settings:

The following code shows how to provide connection settings to the NorthWind database stored on the local MS SQLServer. The connection string is generated by the static MSSqlConnectionProvider.GetConnectionString method, which takes the names of the server and database, user name and password as parameters.

See the Grid Server Mode and Grid Instant Feedback UI demos for complete examples of implementing server modes.

Expanded See Also

How would you rate this topic?​​​​​​​