[Expand]General Information
[Expand]WinForms Controls
[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]Office File API
[Expand]Reporting
[Expand]Report and Dashboard Server
[Collapse]Dashboard
 [Expand]Getting Started
 [Expand]Basic Concepts and Terminology
 [Expand]Common Features
 [Expand]Creating the Designer and Viewer Applications
 [Collapse]Creating Dashboards
  [Collapse]Creating Dashboards in the WinForms Designer
    Creating a Dashboard
   [Collapse]Providing Data
    [Collapse]SQL Data Source
     [Collapse]Connecting to SQL Databases
       Microsoft SQL Server
       Microsoft Access 97
       Microsoft Access 2007
       MS SQL Server CE
       Oracle
       Amazon Redshift
       Google BigQuery
       Teradata
       Firebird
       IBM DB2
       MySQL
       Pervasive PSQL
       PostgreSQL
       SAP Sybase Advantage
       SAP Sybase ASE
       SAP Sybase SQL Anywhere
       SQLite
       VistaDB
       VistaDB 5
       XML File
       Custom Connection String
      Editing Connection Parameters
     [Expand]Working with Data
    [Expand]OLAP Data Source
    [Expand]Excel Data Source
    [Expand]Entity Framework Data Source
    [Expand]Object Data Source
    [Expand]Extract Data Source
     Calculated Fields
     Data Processing Modes
    Adding Dashboard Items
   [Expand]Binding Dashboard Items to Data
   [Expand]Designing Dashboard Items
   [Expand]Data Shaping
   [Expand]Interactivity
   [Expand]Appearance Customization
   [Expand]Data Analysis
    Converting Dashboard Items
   [Expand]Dashboard Layout
    Undo and Redo Operations
    Automatic and Manual Updates
    Saving a Dashboard
   [Expand]Printing and Exporting
  [Expand]Creating Dashboards on the Web
  [Expand]Creating Dashboards in the Visual Studio Designer
 [Expand]Visual Studio Integration
  End-User Documentation
  Localization
 [Expand]Redistribution and Deployment
  Video Tutorials
 [Expand]Examples
 [Expand]Member Tables
 [Expand]API Reference
[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)

Connecting to SQL Databases

The WinForms Designer provides the capability to connect to multiple types of SQL databases using the Data Source wizard. You can establish a connection to a database using the two main approaches.

  1. Connect to a database by selecting the required database type in the Data Source wizard. Then, specify the required connection parameters. To learn how to connect to the required type of the SQL database, refer to the following tutorials.

  2. Register a required data connection in the application's configuration file by adding a corresponding connection string to the connectionStrings section.

    This connection will be displayed for end-users in the Data Source wizard when creating a new data source.

    To learn more, see Register Default Data Connections.

Expanded See Also

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