MsSqlConnectionParameters Class

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

Namespace : DevExpress.DataAccess.ConnectionParameters

Assembly : DevExpress.DataAccess.v25.2.dll

NuGet Package : DevExpress.DataAccess

Declaration

C#
VB.NET

csharp

public class MsSqlConnectionParameters :
    SqlServerConnectionParametersBase,
    IConnectionPageEncryption,
    IConnectionPageMsSqlDb

Public Class MsSqlConnectionParameters
    Inherits SqlServerConnectionParametersBase
    Implements IConnectionPageEncryption,
               IConnectionPageMsSqlDb

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#
VB.NET

csharp

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;

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