Export (0) Print
Expand All

SqlConnectionStringBuilder.Password Property

Gets or sets the password for the SQL Server account.

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

public string Password { get; set; }

Property Value

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

ExceptionCondition
ArgumentNullException

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.

using System;
using System.Data.SqlClient;

class Program {
   public static void Main() {
      SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder();

      builder["Password"] = null;
      string aa = builder.Password;
      Console.WriteLine(aa.Length);

      builder["Password"] = "??????";
      aa = builder.Password;
      Console.WriteLine(aa.Length);

      try {
         builder.Password = null;
      }
      catch (ArgumentNullException e) {
         Console.WriteLine("{0}", e);
      }
   }
}

.NET Framework

Supported in: 4.6, 4.5, 4, 3.5, 3.0, 2.0

.NET Framework Client Profile

Supported in: 4, 3.5 SP1
Show:
© 2015 Microsoft