SqlConnectionStringBuilder.Password Property
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Gets or sets the password for the SQL Server account.
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
The password was incorrectly set to null. See code sample below.
Examples
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);
}
}
}
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
Console.WriteLine(aa.Length)
builder("Password") = "??????"
aa = builder.Password
Console.WriteLine(aa.Length)
Try
builder.Password = Nothing
Catch e As ArgumentNullException
Console.WriteLine("{0}", e)
End Try
End Sub
End Class
Remarks
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.