SqlWizardSettings.AvailableDataProviders Property
Specifies which data providers are available on the Specify a Connection String page of the Data Source Wizard.
Namespace: DevExpress.DataAccess.UI.Wizard
Assembly: DevExpress.DataAccess.v24.1.dll
NuGet Packages: DevExpress.DataAccess, DevExpress.Win.PivotGrid, DevExpress.Win.TreeMap
Declaration
[DefaultValue(SqlDataProviders.All)]
public SqlDataProviders AvailableDataProviders { get; set; }Property Value
| Type | Default | Description |
|---|---|---|
| SqlDataProviders | All | One or more SqlDataProviders enumeration values. |
Available values:
| Name | Description |
|---|---|
| None | No data providers are displayed in the Data Source wizard. |
| CustomConnectionString | Identifies the Custom Connection String data provider. |
| MSSqlServer | Identifies the Microsoft SQL Server data provider. |
| MSSqlServerCE | Identifies the MS SQL Server CE data provider. |
| Access | Identifies Micrisoft Access data providers. |
| Oracle | Identifies the Oracle data provider. |
| Redshift | Identifies the Amazon Redshift data provider. |
| BigQuery | Identifies the Google BigQuery data provider. |
| Teradata | Identifies the Teradata data provider. |
| Hana | |
| Firebird | Identifies the Firebird data provider. |
| DB2 | Identifies the IBM DB2 data provider. |
| MySql | Identifies the MySQL data provider. |
| Pervasive | Identifies the Pervasive PSQL data provider. |
| Postgres | Identifies the Postgre SQL data provider. |
| Advantage | Identifies the SAP Sybase Advantage data provider. |
| Ase | Identifies the SAP Sybase ASE data provider. |
| Asa | Identifies the SAP SQL Anywhere data provider. |
| SQLite | Identifies the SQLite data provider. |
| VistaDB | Identifies VistaDB data providers. |
| XmlFile | Identifies the XML File data provider. |
| All | All supported data providers are displayed in the Data Source wizard. |
Property Paths
You can access this nested property as listed below:
| Library | Object Type | Path to AvailableDataProviders |
|---|---|---|
| WinForms Controls | DataSourceWizardSettings |
|
| Dashboard | DashboardDesignerDataSourceWizardSettings |
|
| .NET Reporting Tools | XRDesignMdiController |
|
Remarks
To customize the Data Source and Report wizard pages at design time in the Visual Studio, drop the StandardReportDesigner or RibbonReportDesigner control on a form and select the XRDesignMdiController component.
In the Property Grid, expand the XRDesignMdiController.SqlWizardSettings property and select the required data providers in the AvailableDataProviders property editor.
