dashboard-401400-web-dashboard-create-dashboards-on-the-web-providing-data-create-a-new-data-source-specify-data-source-settings-database.md
Register a data connection string provider.
Install a database provider if necessary.
For information on supported databases and required providers, refer to the following help topic: Supported Data Providers.
The Choose a data connection page appears if you select Database on the start page. Select an existing connection from the list.
For information on how to register data connections in your application, refer to the following help topics:
The next page allows you to create/edit a query or select a stored procedure. The image below displays a generated query in the SQL string editor.
Click Run Query Builder… to launch the Query Builder and choose the tables/columns visually.
If the SQL query contains query parameters, click Next to configure them.
You can use the following approaches to specify a parameter value:
Assign a static value
Provide a dynamic parameter value
Click Finish to create a new data source.
The database wizard pages are identified by the following API:
| Page Name | Page ID | Class |
|---|---|---|
| Choose Connection (Database) | SqlDataSourceWizardPageId.ChooseConnectionPage | ChooseSqlConnectionPage |
| Choose Queries | SqlDataSourceWizardPageId.ConfigureQueryPage | ConfigureQueryPage |
| Configure Query Parameters | SqlDataSourceWizardPageId.ConfigureParametersPage | ConfigureQueryParametersPage |
| Choose Queries (a multi-query version) | SqlDataSourceWizardPageId.MultiQueryConfigurePage | MultiQueryConfigurePage |
| Configure Query Parameters (a multi-query version) | SqlDataSourceWizardPageId.MultiQueryConfigureParametersPage | MultiQueryConfigureParametersPage |
See Also