Skip to main content

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:

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.

Property Paths

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

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.

SqlWizardSettings-AvailableDataProviders

See Also