Skip to main content

SqlDataSource.ConfigureDataConnection Event

Allows you to customize connection settings before connecting to a database.

Namespace: DevExpress.DataAccess.Sql

Assembly: DevExpress.DataAccess.v24.1.dll

NuGet Packages: DevExpress.DataAccess, DevExpress.Win.PivotGrid, DevExpress.Win.TreeMap

Declaration

public event ConfigureDataConnectionEventHandler ConfigureDataConnection

Event Data

The ConfigureDataConnection event's data class is ConfigureDataConnectionEventArgs. The following properties provide information specific to this event:

Property Description
ConnectionName Gets the name of the connection for which the event has been raised.
ConnectionParameters Gets or sets parameters used to establish a connection to data.

Remarks

The ConfigureDataConnection event occurs only if the SqlDataSource.ConnectionParameters property is set. The event is not raised if the ConnectionName was configured instead. The ConfigureDataConnection event fires each time the SqlDataSource connects to a database. Handle this event to change 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.).

Tip

For more information, review the following article: SqlDataSource - How to change connection parameters at runtime.

Use the event parameter’s ConfigureDataConnectionEventArgs.ConnectionName property to identify the connection for which the event is raised. To access connection parameters, use the ConfigureDataConnectionEventArgs.ConnectionParameters property.

The ConfigureDataConnectionEventArgs.ConnectionParameters property returns a DataConnectionParametersBase descendant. Different DataConnectionParametersBase descendants provide connection parameters for different DBMS and data file formats. For instance, the MsSqlConnectionParameters, OracleConnectionParameters, XmlFileConnectionParameters and many other classes are available.

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

See Also