MsSqlConnectionParameters Class

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

Namespace: DevExpress.DataAccess.ConnectionParameters

Assembly: DevExpress.DataAccess.v18.1.dll

Declaration

C#

public class MsSqlConnectionParameters :
    SqlServerConnectionParametersBase

VB.NET

Public Class MsSqlConnectionParameters
    Inherits SqlServerConnectionParametersBase

Remarks

The MsSqlConnectionParameters class instances provide the basic parameters required to establish a Microsoft SQL Server connection: the server name (SqlServerConnectionParametersBase.ServerName), database name (SqlServerConnectionParametersBase.DatabaseName), user name (SqlServerConnectionParametersBase.UserName) and password (SqlServerConnectionParametersBase.Password).

To authenticate with the SQL server account, set the MsSqlConnectionParameters.AuthorizationType property to MsSqlAuthorizationType.SqlServer and provide the credentials via the SqlServerConnectionParametersBase.UserName and SqlServerConnectionParametersBase.Password properties.

To authenticate with the Windows user account, set the MsSqlConnectionParameters.AuthorizationType property to MsSqlAuthorizationType.Windows. In this instance, the current user account credentials will be used and the SqlServerConnectionParametersBase.UserName and SqlServerConnectionParametersBase.Password properties will be ignored.

To learn more about the use of classes that provide data connection parameters, see DataConnectionParametersBase.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the MsSqlConnectionParameters class.

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#

how-to-define-iconnectionstorageservice-filtering-unnecessary-connections-from-appconfig-t281449/CS/WizardConnectionStorageService/Form1.cs#L30

MsSqlConnectionParameters cpNorthwind = new MsSqlConnectionParameters()
{

how-to-configure-the-sql-data-access-component-in-code-to-bind-the-gridcontrol-to-a-databa-t190498/CS/dxSample/Form1.cs#L41

private static SqlDataSource InitData() {
    MsSqlConnectionParameters connectionParameters = new MsSqlConnectionParameters("localhost", "nwind.mdf", "username", "password", MsSqlAuthorizationType.SqlServer);
    SqlDataSource ds = new SqlDataSource(connectionParameters);

winforms-end-user-designer-how-to-customize-the-data-source-wizard-connection-string-stora-t119350/CS/T119350/CustomConnectionStorageService.cs#L38

//Add a connection to the XML file:
SqlDataConnection defaultConnection = new CustomSqlDataConnection("Default Connection", new MsSqlConnectionParameters("localhost", "NORTHWIND", "sa", "dx", MsSqlAuthorizationType.SqlServer));
SaveConnection(defaultConnection.Name, defaultConnection, true);

Reporting_how-to-provide-aspxreportdesigner-with-the-sqldatasource-objectdatasource-t271722/CS/WebApplication1/Default.aspx.cs#L18

MsSqlConnectionParameters connectionParameters = new MsSqlConnectionParameters(".", "NWind", null, null, MsSqlAuthorizationType.Windows);
DevExpress.DataAccess.Sql.SqlDataSource ds = new DevExpress.DataAccess.Sql.SqlDataSource(connectionParameters);

how-to-display-the-total-value-above-each-pie-chart-t543185/CS/ASPxDashboard/Default.aspx.cs#L18

protected void ASPxDashboard1_ConfigureDataConnection(object sender, DevExpress.DashboardWeb.ConfigureDataConnectionWebEventArgs e) {
    MsSqlConnectionParameters cp = e.ConnectionParameters as MsSqlConnectionParameters;
    if (cp != null && cp.DatabaseName == "Northwind") {

VB.NET

how-to-define-iconnectionstorageservice-filtering-unnecessary-connections-from-appconfig-t281449/VB/WizardConnectionStorageService/Form1.vb#L29

Dim cpNorthwind As New MsSqlConnectionParameters() With {.ServerName = "localhost", .AuthorizationType = MsSqlAuthorizationType.Windows, .DatabaseName = "Northwind"}
Dim cpAdventureWorks As New MsSqlConnectionParameters() With {.ServerName = "localhost", .AuthorizationType = MsSqlAuthorizationType.Windows, .DatabaseName = "AdventureWorksDW2012"}

how-to-configure-the-sql-data-access-component-in-code-to-bind-the-gridcontrol-to-a-databa-t190498/VB/dxSample/Form1.vb#L43

Private Shared Function InitData() As SqlDataSource
    Dim connectionParameters As New MsSqlConnectionParameters("localhost", "nwind.mdf", "username", "password", MsSqlAuthorizationType.SqlServer)
    Dim ds As New SqlDataSource(connectionParameters)

winforms-end-user-designer-how-to-customize-the-data-source-wizard-connection-string-stora-t119350/VB/T119350/CustomConnectionStorageService.vb#L40

'Add a connection to the XML file:
Dim defaultConnection As SqlDataConnection = New CustomSqlDataConnection("Default Connection", New MsSqlConnectionParameters("localhost", "NORTHWIND", "sa", "dx", MsSqlAuthorizationType.SqlServer))
SaveConnection(defaultConnection.Name, defaultConnection, True)

Reporting_how-to-provide-aspxreportdesigner-with-the-sqldatasource-objectdatasource-t271722/VB/WebApplication1/Default.aspx.vb#L17

Dim connectionParameters As New MsSqlConnectionParameters(".", "NWind", Nothing, Nothing, MsSqlAuthorizationType.Windows)
Dim ds As New DevExpress.DataAccess.Sql.SqlDataSource(connectionParameters)

how-to-display-the-total-value-above-each-pie-chart-t543185/VB/ASPxDashboard/Default.aspx.vb#L20

Protected Sub ASPxDashboard1_ConfigureDataConnection(ByVal sender As Object, ByVal e As DevExpress.DashboardWeb.ConfigureDataConnectionWebEventArgs)
    Dim cp As MsSqlConnectionParameters = TryCast(e.ConnectionParameters, MsSqlConnectionParameters)
    If cp IsNot Nothing AndAlso cp.DatabaseName = "Northwind" Then

Inheritance

Object

DataConnectionParametersBase

SqlServerConnectionParametersBase

MsSqlConnectionParameters