Password Property (SqlConnection)

On this page

Gets or sets the user's password to connect.

Syntax

Visual Basic
C#


'Declaration Public Property Password As String


public string Password {get; set;}

Property Value

The user's password 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 password.

csharp


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

public void CreateSqlConnection()
{
  string myConnString = 
      "User Id=sa;Server=localhost;Initial Catalog=Test;";
  SqlConnection myConnection = new SqlConnection(myConnString);
  myConnection.Open();
  MessageBox.Show("Password: " + myConnection.Password.ToString());
  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("Password: " + myConnection.Password.ToString()) 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("Password: " + myConnection.Password.ToString())
  myConnection.Close()
End Sub

Reference

SqlConnection Class
SqlConnection Members
UserId Property
ConnectionString Property

Send Feedback