ConfigureDataConnectionEventArgs.ConnectionParameters Property

Gets or sets parameters used to establish a connection to data.

Namespace: DevExpress.DataAccess.Sql

Assembly: DevExpress.DataAccess.v24.2.dll

Declaration

C#

public DataConnectionParametersBase ConnectionParameters { get; set; }

VB.NET

Public Property ConnectionParameters As DataConnectionParametersBase

Property Value

Type	Description
DataConnectionParametersBase	A DataConnectionParametersBase descendant that contains parameters used to establish a connection to data.

Remarks

The ConnectionParameters property specifies a DataConnectionParametersBase descendant that provides parameters required to establish a connection to data (for instance, the server name, the database name, user credentials, the path to a data file, etc).

Different DataConnectionParametersBase descendants provide connection parameters for different DBMS and data file formats. For instance, MsSqlConnectionParameters, OracleConnectionParameters, XmlFileConnectionParameters and many other classes are available.

To edit the current connection parameters, cast the returned DataConnectionParametersBase object to an appropriate descending type and then adjust the parameters. To change the data provider, create an object of an appropriate descending type, customize the parameters and assign the created object to the ConnectionParameters property.

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#

asp-net-web-forms-dashboard-register-data-sources/CS/WebFormsDashboardDataSources/Pages/ExtractDashboard.aspx.cs#L34

    extractParams.FileName = HostingEnvironment.MapPath(@"~/App_Data/SalesPersonExtract.dat");
    e.ConnectionParameters = extractParams;
}

asp-net-mvc-dashboard-register-data-sources/CS/MvcDashboardDataSources/Configuration/ExcelDataSourceConfigurator.cs#L21

    var excelParams = new ExcelDataSourceConnectionParameters(HostingEnvironment.MapPath(@"~/App_Data/Sales.xlsx"));
    e.ConnectionParameters = excelParams;
}

mvc-dashboard-separate-server-settings-for-different-views/CS/MvcDashboard_ServerSideApi/Global.asax.cs#L32

    if (e.ConnectionName == "Northwind connection")
        e.ConnectionParameters = new Access97ConnectionParameters(databasePath, "", "");
};

WebFormsDashboardConfigurator/CS/WebFormsDashboardConfigurator/Global.asax.cs#L41

        + "Initial catalog=Adventure Works DW Standard Edition;Cube name=Adventure Works;Query Timeout=100;";
    e.ConnectionParameters = olapParams;
}

asp-net-web-forms-dashboard-switch-between-designer-and-viewer-on-client/CS/Dashboard_WebDashboard_2010/WebForm1.aspx.cs#L36

    string databasePath = HostingEnvironment.MapPath("~/App_Data/DashboardEnergyStatictics.xml");
    e.ConnectionParameters = new XmlFileConnectionParameters(databasePath);
}

VB.NET

asp-net-web-forms-dashboard-register-data-sources/VB/WebFormsDashboardDataSources/Pages/OlapDashboard.aspx.vb#L31

    olapParams.ConnectionString = "Provider=MSOLAP;Data Source=http://demos.devexpress.com/Services/OLAP/msmdpump.dll;" & "Initial catalog=Adventure Works DW Standard Edition;Cube name=Adventure Works;Query Timeout=100;"
    e.ConnectionParameters = olapParams
End If

asp-net-mvc-dashboard-register-data-sources/VB/MvcDashboardDataSources/Configuration/OlapDataSourceConfigurator.vb#L20

    olapParams.ConnectionString = "Provider=MSOLAP;Data Source=http://demos.devexpress.com/Services/OLAP/msmdpump.dll;" & "Initial catalog=Adventure Works DW Standard Edition;Cube name=Adventure Works;Query Timeout=100;"
    e.ConnectionParameters = olapParams
End If

mvc-dashboard-separate-server-settings-for-different-views/VB/MvcDashboard_ServerSideApi/Global.asax.vb#L36

If e.ConnectionName = "Northwind connection" Then
    e.ConnectionParameters = New Access97ConnectionParameters(databasePath, "", "")
End If

WebFormsDashboardConfigurator/VB/WebFormsDashboardConfigurator/Global.asax.vb#L42

    olapParams.ConnectionString = "Provider=MSOLAP;Data Source=http://demos.devexpress.com/Services/OLAP/msmdpump.dll;" & "Initial catalog=Adventure Works DW Standard Edition;Cube name=Adventure Works;Query Timeout=100;"
    e.ConnectionParameters = olapParams
End If

asp-net-web-forms-dashboard-switch-between-designer-and-viewer-on-client/VB/Dashboard_WebDashboard_2010/WebForm1.aspx.vb#L35

    Dim databasePath As String = HostingEnvironment.MapPath("~/App_Data/DashboardEnergyStatictics.xml")
    e.ConnectionParameters = New XmlFileConnectionParameters(databasePath)
End If