SqlConnectionStringBuilder.Password Property

public:
 property System::String ^ Password { System::String ^ get(); void set(System::String ^ value); };

public string Password { get; set; }

member this.Password : string with get, set

Public Property Password As String

Property Value

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

Exceptions

Examples

The following example shows how to set Password.

using System;
using Microsoft.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);
 }
 }
}

Remarks

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

Setting this property is not recommended. To maintain a high level of security, we strongly recommend that you use the Integrated Security or Trusted_Connection keyword instead. SqlCredential is a more secure way to specify credentials for a connection that uses SQL Server Authentication.

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 password must be 128 characters or fewer.