ContextQMD
Back to Devexpress

Data Source Configuration Wizard

windowsforms-16633-common-features-data-binding-data-source-configuration-wizard.md

latest3.0 KB
Original Source

Data Source Configuration Wizard

  • Dec 10, 2021
  • 4 minutes to read

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.

Note

.NET Support

In v21.2 and higher, the Data Source Configuration Wizard is available in projects that target .NET 5. The wizard is not available in more recent versions of .NET.

The wizard currently supports only the following data source types in .NET projects:

  • ADO.NET DataSet
  • XPO
  • Entity Framework
  • MongoDB
  • JSON
  • Excel sheets
  • Unbound or XML data

The first page of the Data Source Configuration Wizard contains the following sections:

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

  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.