corelibraries-devexpress-dot-dataaccess-dot-wizard-dot-services-dot-iconnectionproviderservice-dot-loadconnection-x28-system-dot-string-x29.md
Loads the specified SqlDataConnection.
Namespace : DevExpress.DataAccess.Wizard.Services
Assembly : DevExpress.DataAccess.v25.2.dll
NuGet Package : DevExpress.DataAccess
SqlDataConnection LoadConnection(
string connectionName
)
Function LoadConnection(
connectionName As String
) As SqlDataConnection
| Name | Type | Description |
|---|---|---|
| connectionName | String |
A String value, specifying the connection name.
|
| Type | Description |
|---|---|
| SqlDataConnection |
An SqlDataConnection object.
|
The following code shows how to implement the IConnectionProviderService interface:
using DevExpress.DataAccess.ConnectionParameters;
using DevExpress.DataAccess.Sql;
using DevExpress.DataAccess.Wizard.Services;
// ...
public class CustomConnectionProviderService : IConnectionProviderService {
public SqlDataConnection LoadConnection(string connectionName) {
// Specify custom connection parameters.
return new SqlDataConnection(connectionName,
new MsSqlConnectionParameters("localhost", "dataBaseName", "userName", "password", MsSqlAuthorizationType.Windows));
}
}
Imports DevExpress.DataAccess.ConnectionParameters
Imports DevExpress.DataAccess.Sql
Imports DevExpress.DataAccess.Wizard.Services
' ...
Public Class CustomConnectionProviderService
Implements IConnectionProviderService
Public Function LoadConnection(connectionName As String) As SqlDataConnection Implements IConnectionProviderService.LoadConnection
' Specify custom connection parameters.
Return New SqlDataConnection(connectionName, _
New MsSqlConnectionParameters("localhost", "dataBaseName", "userName", "password", MsSqlAuthorizationType.Windows))
End Function
End Class
The IConnectionProviderService.LoadConnection method is invoked for each connection that is serialized in the report definition file. Use the connectionName parameter to specify connection options and return an SqlDataConnection object.
Use the implemented interface in an application that invokes a report‘s Print Preview or End-User Report Designer :
Windows Forms
WPF
Web Report Viewer and Designer
See Also
IConnectionProviderService Interface