UserName 屬性

Gets or sets the user name for the connection, if you do not use Windows Authentication.

命名空間：  Microsoft.SqlServer.Dts.ManagedConnections
組件：  Microsoft.SqlServer.ManagedConnections (在 Microsoft.SqlServer.ManagedConnections.dll 中)

語法

'宣告
Public Property UserName As String
    Get
    Set
'用途
Dim instance As WMIConn
Dim value As String

value = instance.UserName

instance.UserName = value

public string UserName { get; set; }

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

member UserName : string with get, set

function get UserName () : String
function set UserName (value : String)

屬性值

型別：System. . :: . .String
A String that contains the user name for the connection.

備註

If you do not use Windows Authentication, you must provide a user name and password for the connection.

範例

The following code example adds a WMI connection to a package, and sets the ServerName, UserName, and Password properties. The code example needs to be modified to have the appropriate values supplied for the properties for your application.

ConnectionManager WmiConn = pkg.Connections.Add("WMI");
DtsProperty prop = WmiConn.Properties["ServerName"];
prop.SetValue(WmiConn, @"\\localhost");
WmiConn.Properties["Username"].SetValue(WmiConn, @"");
WmiConn.Properties["Password"].SetValue(WmiConn, @"");

Dim WmiConn As ConnectionManager =  pkg.Connections.Add("WMI") 
Dim prop As DtsProperty =  WmiConn.Properties("ServerName") 
prop.SetValue(WmiConn, "\\localhost")
WmiConn.Properties("Username").SetValue(WmiConn, @"")
WmiConn.Properties("Password").SetValue(WmiConn, @"")

請參閱

參考

WMIConn類別

WMIConn 成員

Microsoft.SqlServer.Dts.ManagedConnections 命名空間