Password Property (SqlConnection)

In This Topic

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

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

Reference

SqlConnection Class
SqlConnection Members
UserId Property
ConnectionString Property

Send Feedback