SqlConnectionStringBuilder.Values 屬性

定義

命名空間:

System.Data.SqlClient

組件:

System.Data.SqlClient.dll

套件:

System.Data.SqlClient v4.8.6

取得包含 ICollection 中之值的 SqlConnectionStringBuilder。

public:
 virtual property System::Collections::ICollection ^ Values { System::Collections::ICollection ^ get(); };

public override System.Collections.ICollection Values { get; }

member this.Values : System.Collections.ICollection

Public Overrides ReadOnly Property Values As ICollection

屬性值

ICollection

ICollection，其中包含 SqlConnectionStringBuilder 中的值。

範例

下列範例會先建立新的 SqlConnectionStringBuilder，然後逐一查看此物件內的所有值。

using System.Data.SqlClient;

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

        // Loop through each of the values, displaying the contents.
        foreach (object value in builder.Values)
            Console.WriteLine(value);

        Console.WriteLine("Press any key to continue.");
        Console.ReadLine();
    }

    private static string GetConnectionString()
    {
        // To avoid storing the connection string in your code,
        // you can retrieve it from a configuration file.
        return "Data Source=(local);Integrated Security=SSPI;" +
            "Initial Catalog=AdventureWorks; Asynchronous Processing=true";
    }
}

Imports System.Data.SqlClient
    
Module Module1
    Sub Main()
        Dim builder As _
         New SqlConnectionStringBuilder(GetConnectionString())

        ' Loop through each of the values, displaying the contents.
        For Each value As Object In builder.Values
            Console.WriteLine(value)
        Next

        Console.WriteLine("Press any key to continue.")
        Console.ReadLine()
    End Sub

    Private Function GetConnectionString() As String
        ' To avoid storing the connection string in your code,
        ' you can retrieve it from a configuration file. 
        Return "Data Source=(local);Integrated Security=SSPI;" & _
          "Initial Catalog=AdventureWorks; Asynchronous Processing=True"
    End Function
End Module

備註

雖然 ICollection 中值的順序並未指定，但此順序會與 ICollection 屬性傳回之 Keys 中關聯索引鍵的順序相同。 因為每一個 SqlConnectionStringBuilder 執行個體一定會包含相同的固定索引鍵集合，所以 Values 屬性會依照與索引鍵相同的順序，傳回對應至此固定索引鍵集合的值。

另請參閱

• Keys
• ADO.NET 中的連接字串
• ADO.NET 概觀 \(部分機器翻譯\)