MsSqlConnectionParameters Class

Contains parameters used to establish a connection to a Microsoft SQL Server.

Namespace: DevExpress.DataAccess.ConnectionParameters

Assembly: DevExpress.DataAccess.v23.2.dll

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

Declaration

C#

public class MsSqlConnectionParameters :
    SqlServerConnectionParametersBase,
    IConnectionPageEncryption

VB.NET

Public Class MsSqlConnectionParameters
    Inherits SqlServerConnectionParametersBase
    Implements IConnectionPageEncryption

Remarks

The MsSqlConnectionParameters class includes the basic parameters needed to establish connection to the Microsoft SQL Server.

The following code snippet specifies connection parameters:

C#

using DevExpress.DataAccess.ConnectionParameters;
using DevExpress.DataAccess.Sql;
// ...
MsSqlConnectionParameters connectionParameters = new MsSqlConnectionParameters(){
    ServerName = "localhost",
    DatabaseName = "Northwind",
    UserName = "username",
    Password = "password",
    AuthorizationType = MsSqlAuthorizationType.SqlServer,
    TrustServerCertificate = DevExpress.Utils.DefaultBoolean.True,
    Encrypt = DevExpress.Utils.DefaultBoolean.True
};
SqlDataSource ds = new SqlDataSource();
ds.ConnectionName = "nwindConnection";
ds.ConnectionParameters = connectionParameters;

VB.NET

Imports DevExpress.DataAccess.ConnectionParameters
Imports DevExpress.DataAccess.Sql;
' ...
Dim connectionParameters As MsSqlConnectionParameters = New MsSqlConnectionParameters() With {
    .ServerName = "localhost",
    .DatabaseName = "Northwind",
    .UserName = "username",
    .Password = "password",
    .AuthorizationType = MsSqlAuthorizationType.SqlServer,
    .TrustServerCertificate = DevExpress.Utils.DefaultBoolean.True,
      .Encrypt = DevExpress.Utils.DefaultBoolean.True
}
Dim ds As SqlDataSource = New SqlDataSource()
ds.ConnectionName = "nwindConnection"
ds.ConnectionParameters = connectionParameters   

For more information, review the following help topic: Specify Data Connection.

Inheritance

Object

DataConnectionParametersBase

SqlServerConnectionParametersBase

MsSqlConnectionParameters