Log In
Home
Support
Demos
Documentation
Blogs
Training
Webinars
[Expand]General Information
[Collapse]WinForms Controls
  Prerequisites
 [Expand]What's Installed
 [Expand]Build an Application
 [Expand]Controls and Libraries
 [Collapse]Common Features
  [Collapse]Data Binding Common Concepts
    How to: Bind GridControl to Database and Implement Master-Detail Mode at Design Time
    How to: Bind a Control to a Database at Runtime
    How to: Bind a Control to Data Created at Runtime
    How to: Bind a Control to Data in an XML File
    Traditional Data Binding Methods
    Data Source Configuration Wizard
    Data Binding Mechanism in ADO.NET
    Binding Controls to XML Data
    Binding Controls to Data Created at Runtime
    Add Unbound Data to a Data-Aware Control (XtraGrid, XtraPivotGrid)
    Binding to Excel Data Sources
    Binding to LINQ to SQL Classes
    Unbound Sources
    Binding to Entity Framework Core
    Binding to OData
    Binding to SQL Data
    Data Annotation Attributes
    How to: Add Virtual Rows Using the UnboundSource Component
    Obtaining Fields Available in Data Source
  [Expand]Data Source Wizard
  [Expand]Expressions
  [Expand]Behaviors
  [Expand]Application Appearance
  [Expand]Filtering UI Context
  [Expand]High DPI Support
  [Expand]Scaffolding Wizard
  [Expand]Formatting Values
   HTML Text Formatting
  [Expand]Menus
  [Expand]Tooltip Management
  [Expand]Saving and Restoring Layouts
   Clipboard - Copy and Paste Operations. Data Formatting
   Version Compatibility: Default Property Values
  Get More Help
 [Expand]API Reference
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Document Server
[Expand]Reporting
[Expand]Report Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

Data Source Configuration Wizard

The Data Source Configuration Wizard simplifies the process of binding a data-aware DevExpress control (such as GridControl or TreeList) to a data source. To invoke this wizard, click the control's smart tag to invoke the tasks list, and click the corresponding link, as shown in the figure below.

The first page of the invoked wizard contains the following sections:

  1. Data Access Technology - You can select the required data source type from one of the following.

    Data Access Technology
    Description
    ADO.NET Typed DataSet The memory-resident representation of data that provides a consistent relational programming model regardless of the data source. To learn more, see the Data Binding Mechanism in ADO.NET topic.
    SQL Data Connection Uses the SqlDataSource component to create and run SQL queries and specify master-detail relations between them. See this tutorial for more details.
    Excel Data Source Uses the ExcelDataSource component to bind to data from Microsoft Excel workbooks (XLS, XLSX or XLSM files) or CSV files.
    Unbound Data Source Uses the UnboundDataSource component to populate data-aware controls in unbound mode.
    Entity Framework The Microsoft® ADO.NET Entity Framework is an Object/Relational Mapping (ORM) framework that represents relational data as domain-specific objects.
    Entity Framework (EF) Core Entity Framework (EF) Core is a lightweight, extensible, and cross-platform version of the popular Entity Framework data access technology.
    Linq to SQL A Language-Integrated Query (LINQ) provider that translates language-integrated queries into the required SQL queries, and tabular results into defined objects. To learn more, see Binding to LINQ to SQL Classes.
    WCF Data Services WCF Data Services allow you to use the Open Data protocol (versions 2 and 3) to query data over the HTTP protocol.
    OData V4 Services OData V4 is an open protocol initiated by Microsoft. Its RESTful API allows you to publish, read and edit resources defined in a data model using simple HTTP messages.
    DevExpress ORM Tool (XPO) eXpress Persistent Objects (or XPO) bridges the gap between relational databases and object oriented software constructs found in custom software. Using XPO, you can build applications that are compatible with multiple database systems without having to make any changes in your code. This option will invoke Visual Studio's 'Add New Item' dialog that allows you to add either code first or model first persistent object. See this section to learn more.
    IList, IEnumerable Any data source implementing the IList or IEnumerable interface.
    XML Data Any XML data source. See the Binding Controls to XML Data topic for details.
  2. Data Sources - This region displays the existing data sources for the project of the selected type. To create a new data source, click the New Data Source... button, which will close the current Data Source Configuration Wizard and invoke a new wizard. After you add a new data source, rebuild your solution and launch the Data Source Configuration Wizard again - your data source will be displayed in this region.

Choose the data source and click the Next button to go to the next page.

The second page contains options that allow you to choose the required Data Processing Mode. This page may vary depending on the Data Access Technology selected in the previous screen. The following image illustrates the Data Processing Mode options available for the ADO.NET Typed DataSet technology.

  1. Data Processing Mode defines algorithms for binding the control to data.
  2. Description describes the selected Mode.

Select the Mode based on your requirements (e.g., data capacity, parallel data processing) and click Next to go to the next page.

The third page allows you to specify advanced customization options for the selected data source and data processing mode (e.g., sorting and filtering). Again, this page can differ depending on the control and the selected Data Access Technology.

After you have set all required options, click Finish. If the 'Show generated code-behind after Wizard is closed' option is checked, the wizard will automatically navigate to the auto-generated code behind.

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