UserId Property (SqlConnection)

In This Topic

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();
}

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

Reference

SqlConnection Class
SqlConnection Members
Password Property
ConnectionString Property

Send Feedback