SqlConnectionStringBuilder.Password Property


The .NET API Reference documentation has a new home. Visit the .NET API Browser on docs.microsoft.com to see the new experience.

Gets or sets the password for the SQL Server account.

Namespace:   System.Data.SqlClient
Assembly:  System.Data (in System.Data.dll)

Public Property Password As String

Property Value

Type: System.String

The value of the Password property, or String.Empty if none has been supplied.

Exception Condition

The password was incorrectly set to null. See code sample below.

This property corresponds to the "Password" and "pwd" keys within the connection string.

If Password has not been set and you retrieve the value, the return value is Empty. To reset the password for the connection string, pass null to the Item property.

The following example shows how to set Password.

Imports System.Data.SqlClient
Public Class Program
   Public Shared Sub Main()

      Dim builder As New SqlConnectionStringBuilder()

      builder("Password") = Nothing
      Dim aa As String = builder.Password

      builder("Password") = "??????"
      aa = builder.Password

         builder.Password = Nothing
      Catch e As ArgumentNullException
         Console.WriteLine("{0}", e)
      End Try
   End Sub
End Class

.NET Framework
Available since 2.0
Return to top