windowsforms-devexpress-dot-dataaccess-dot-ui-dot-wizard-dot-sqlwizardsettings-c30d8d62.md
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.v25.2.dll
NuGet Package : DevExpress.DataAccess
[DefaultValue(SqlDataProviders.All)]
public SqlDataProviders AvailableDataProviders { get; set; }
<DefaultValue(SqlDataProviders.All)>
Public Property AvailableDataProviders As SqlDataProviders
| Type | Default | Description |
|---|---|---|
| SqlDataProviders | All |
One or more SqlDataProviders enumeration values.
|
Available values:
Show 22 items
| 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.
|
You can access this nested property as listed below:
| Library | Object Type | Path to AvailableDataProviders |
|---|---|---|
| WinForms Controls | DataSourceWizardSettings |
.SqlWizardSettings .AvailableDataProviders
| | Dashboard | DashboardDesignerDataSourceWizardSettings |
.SqlWizardSettings .AvailableDataProviders
| | .NET Reporting Tools | XRDesignMdiController |
.SqlWizardSettings .AvailableDataProviders
|
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.
See Also