WebConfigurationManager.ConnectionStrings 屬性

定義

命名空間:

System.Web.Configuration

組件:

System.Web.dll

取得網站的連接字串。

public:
 static property System::Configuration::ConnectionStringSettingsCollection ^ ConnectionStrings { System::Configuration::ConnectionStringSettingsCollection ^ get(); };

public static System.Configuration.ConnectionStringSettingsCollection ConnectionStrings { get; }

member this.ConnectionStrings : System.Configuration.ConnectionStringSettingsCollection

Public Shared ReadOnly Property ConnectionStrings As ConnectionStringSettingsCollection

屬性值

ConnectionStringSettingsCollection

ConnectionStringSettingsCollection 物件，包含目前 Web 應用程式預設組態之 ConnectionStringsSection 物件的內容。

例外狀況

ConfigurationErrorsException

無法擷取有效的 ConnectionStringSettingsCollection 物件。

範例

下列範例示範如何使用 ConnectionStrings 屬性來存取組態資訊，並列舉結果。 若要存取特定的連接字串，請使用以所需連接字串名稱傳 ConnectionStringSettingsCollection 回的 作為索引子。

// Show the use of the ConnectionString property
// to get the connection strings.
static void GetConnectionStrings()
{

    // Get the connectionStrings key,value pairs collection.
    ConnectionStringSettingsCollection connectionStrings =
        WebConfigurationManager.ConnectionStrings
        as ConnectionStringSettingsCollection;

    // Get the collection enumerator.
    IEnumerator connectionStringsEnum =
        connectionStrings.GetEnumerator();

    // Loop through the collection and 
    // display the connectionStrings key, value pairs.
    int i = 0;
    Console.WriteLine("[Display connectionStrings]");
    while (connectionStringsEnum.MoveNext())
    {
        string name = connectionStrings[i].Name;
        Console.WriteLine("Name: {0} Value: {1}",
        name, connectionStrings[name]);
        i += 1;
    }

    Console.WriteLine();
}

' Show the use of ConnectionStrings property
' to get the connection strings. 
Shared Sub GetConnectionStrings()
   
   ' Get the connectionStrings key,value pairs collection.
     Dim connectionStrings As ConnectionStringSettingsCollection = _
     WebConfigurationManager.ConnectionStrings
   
   ' Get the collection enumerator.
     Dim connectionStringsEnum As IEnumerator = _
     connectionStrings.GetEnumerator()
   
   ' Loop through the collection and 
   ' display the connectionStrings key, value pairs.
   Dim i As Integer = 0
   Console.WriteLine("[Display connectionStrings]")
   While connectionStringsEnum.MoveNext()
      Dim name As String = connectionStrings(i).Name
         Console.WriteLine("Name: {0} Value: {1}", _
         name, connectionStrings(name))
      i += 1
   End While
   
   Console.WriteLine()
End Sub

另請參閱

• ConnectionStringsSection
• ConnectionStringSettingsCollection