UserId Property (SqlConnection)

On this page

Gets or sets the name of the user to connect.

Syntax

Visual Basic
C#


'Declaration Public Property UserId As String


public string UserId {get; set;}

Property Value

The name of the user to connect.

Remarks

When a value is assigned to this property, the SqlConnection is closed.

Example

The following example creates a SqlConnection and displays the user name.

csharp


public void CreateSqlConnection() { string myConnString = "User Id=sa;Server=localhost;Initial Catalog=Test;"; SqlConnection myConnection = new SqlConnection(myConnString); myConnection.Open(); MessageBox.Show("User: " + myConnection.UserId); myConnection.Close(); }

public void CreateSqlConnection()
{
  string myConnString = 
      "User Id=sa;Server=localhost;Initial Catalog=Test;";
  SqlConnection myConnection = new SqlConnection(myConnString);
  myConnection.Open();
  MessageBox.Show("User: " + myConnection.UserId);
  myConnection.Close();
}

Visual Basic


Public Sub CreateSqlConnection() Dim myConnString As String = _ "User Id=sa;Server=localhost;Initial Catalog=Test;" Dim myConnection As New SqlConnection(myConnString) myConnection.Open() MessageBox.Show("User: " + myConnection.UserId) myConnection.Close() End Sub

Public Sub CreateSqlConnection()
  Dim myConnString As String = _
      "User Id=sa;Server=localhost;Initial Catalog=Test;"
  Dim myConnection As New SqlConnection(myConnString)
  myConnection.Open()
  MessageBox.Show("User: " + myConnection.UserId)
  myConnection.Close()
End Sub

Reference

SqlConnection Class
SqlConnection Members
Password Property
ConnectionString Property

Send Feedback