SqlDataSource.ConnectionParameters Property

Specifies the data connection settings of the SqlDataSource.

Namespace: DevExpress.DataAccess.Sql

Assembly: DevExpress.DataAccess.v18.2.dll

Declaration

C#

[DefaultValue(null)]
[TypeConverter(typeof(SqlDataSource.ConnectionParametersTypeConverter))]
[LocalizableCategory(DataAccessStringId.PropertyGridConnectionCategoryName)]
public DataConnectionParametersBase ConnectionParameters { get; set; }

VB.NET

<DefaultValue(Nothing)>
<TypeConverter(GetType(SqlDataSource.ConnectionParametersTypeConverter))>
<LocalizableCategory(DataAccessStringId.PropertyGridConnectionCategoryName)>
Public Property ConnectionParameters As DataConnectionParametersBase

Property Value

Type	Default	Description
DataConnectionParametersBase	*null*	A DataConnectionParametersBase descendant, specifying the connection parameters of the SqlDataSource.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the ConnectionParameters property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

how-to-combine-filter-elements-to-a-group-and-bind-them-to-data-t191632/CS/Dashboard_FilterElements_and_Groups/Form1.cs#L21

DashboardSqlDataSource dataSource = new DashboardSqlDataSource();
dataSource.ConnectionParameters =
    new XmlFileConnectionParameters(@"..\..\Data\WebsiteStatisticsData.xml");

how-to-implement-a-custom-logic-for-writing-data-to-reading-data-from-a-data-extract-t437252/CS/Dashboard_CustomExtractDriver/Form1.cs#L15

Access2007ConnectionParameters connectionParams = new Access2007ConnectionParameters(@"..\..\Data\Northwind.accdb", "");
sqlDataSource.ConnectionParameters = connectionParams;

how-to-bind-a-choropleth-map-dashboard-item-to-data-in-code-e5010/CS/Dashboard_CreateChoroplethMap/Form1.cs#L16

CustomSqlQuery sqlQuery = new CustomSqlQuery("Countries", "select * from Countries");
dataSource.ConnectionParameters = new Access97ConnectionParameters(@"..\..\Data\countriesDB.mdb", "", "");
dataSource.Queries.Add(sqlQuery);

how-to-bind-a-pie-map-dashboard-item-to-data-in-code-t119627/CS/Dashboard_CreatePieMap/Form1.cs#L18

DashboardSqlDataSource xmlDataSource = new DashboardSqlDataSource();
xmlDataSource.ConnectionParameters =
    new XmlFileConnectionParameters(@"..\..\Data\DashboardEnergyStatictics.xml");

how-to-bind-a-geo-point-map-dashboard-item-to-data-in-code-e5036/CS/Dashboard_CreateGeoPointMap/Form1.cs#L14

CustomSqlQuery sqlQuery = new CustomSqlQuery("Cities", "select * from Cities");
dataSource.ConnectionParameters =
    new Access97ConnectionParameters(@"..\..\Data\Cities.mdb", "", "");

VB.NET

how-to-combine-filter-elements-to-a-group-and-bind-them-to-data-t191632/VB/Dashboard_FilterElements_and_Groups/Form1.vb#L23

Dim dataSource As New DashboardSqlDataSource()
dataSource.ConnectionParameters = New XmlFileConnectionParameters("..\..\Data\WebsiteStatisticsData.xml")
Dim selectQuery As SelectQuery = SelectQueryFluentBuilder.AddTable("Data").SelectColumns("Browser", "BrowserDetails", "Date", "Count").Build("Statistics")

how-to-bind-a-choropleth-map-dashboard-item-to-data-in-code-e5010/VB/Dashboard_CreateChoroplethMap/Form1.vb#L17

Dim sqlQuery As New CustomSqlQuery("Countries", "select * from Countries")
dataSource.ConnectionParameters = New Access97ConnectionParameters("..\..\Data\countriesDB.mdb", "", "")
dataSource.Queries.Add(sqlQuery)

how-to-bind-a-pie-map-dashboard-item-to-data-in-code-t119627/VB/Dashboard_CreatePieMap/Form1.vb#L19

Dim xmlDataSource As New DashboardSqlDataSource()
xmlDataSource.ConnectionParameters = New XmlFileConnectionParameters("..\..\Data\DashboardEnergyStatictics.xml")
Dim sqlQuery As SelectQuery = SelectQueryFluentBuilder.AddTable("Countries").SelectColumns("Latitude", "Longitude", "Production", "EnergyType", "Country").Build("Query 1")

how-to-bind-a-geo-point-map-dashboard-item-to-data-in-code-e5036/VB/Dashboard_CreateGeoPointMap/Form1.vb#L16

Dim sqlQuery As New CustomSqlQuery("Cities", "select * from Cities")
dataSource.ConnectionParameters = New Access97ConnectionParameters("..\..\Data\Cities.mdb", "", "")
dataSource.Queries.Add(sqlQuery)