Skip to main content
All docs
V25.2
  • Data Source Wizard

    • 2 minutes to read

    The Data Source Wizard allows you to configure a data source and retrieve its data.

    The first page allows you to create or select an existing data connection.

    win-data-source-wizard-existing-connection

    If you chose a new connection, the next page allows you to select the data connection type.

    WinForms Data Source Wizard

    You can select a provider and click the “star” icon to pin frequently used database providers as favorites. Favorite providers appear at the top of the list for quick access:

    data-source-wizard-favorites

    Use the search panel to filter the connection type list:

    data-source-wizard-search-panel

    This wizard is similar to the Data Source Wizard available in the Visual Studio Report Designer, but the WinForms version does not include the following pages:

    • Save the Connection String page for the Database, JSON, MongoDB, and XPO data sources.
    • Pages that prompt you to install a NuGet package for the JSON or MongoDB data source.

    Supported Data Source Types

    The wizard supports the following data source types:

    • SQL Databases

      Obtains data from all major data providers (Microsoft SQL Server, XML data, Microsoft Access, Oracle, etc.).

      A list of supported SQL data sources is available in the following help topic: Supported Databases.

    • Entity Framework

      Binds to a Microsoft ADO.NET Entity Framework data source.

    • Object

      Connects to any data object that implements the IList, IList<T> or IEnumerable<T> interface.

    • Excel File

      Obtains data from Microsoft Excel workbooks (XLS, XLSX, or XLSM files) or CSV files.

    • JSON

      Connects to JSON-formatted data. The WinForms Data Source Wizard displays this option if the application references the System.Text.Json library.

    • Data Federation

      Retrieves data from multiple data sources.

    • Custom Connection String

      A custom connection string allows you to pass additional connection parameters and establish a connection to any SQL database.

    • MongoDB

      Connects to a MongoDB instance. The WinForms Data Source Wizard displays this option if the MongoDB.Driver package is installed in your project.

    • XPO

      Binds to XPO data. This option is initially hidden in the WinForms Data Source Wizard.

    To customize the list of displayed data connection types, use the DataSourceWizardSettings.AvailableDataSourceTypes property. You can also limit the number of SQL data providers displayed on the Select a Data Connection Type page. Use the SqlWizardSettings.AvailableDataProviders property.