Note

Access to this page requires authorization. You can try signing in or .

Access to this page requires authorization. You can try .

SqlConnectionStringBuilder.Password Property

Definition

Namespace:
System.Data.SqlClient
Assembly:
System.Data.SqlClient.dll
Assembly:
System.Data.dll
Source:
System.Data.SqlClient.notsupported.cs

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.

Applies to

See also


Feedback

Was this page helpful?