แก้ไข

แชร์ผ่าน


ConnectionStringsSection.ConnectionStrings Property

Definition

public:
 property System::Configuration::ConnectionStringSettingsCollection ^ ConnectionStrings { System::Configuration::ConnectionStringSettingsCollection ^ get(); };
[System.Configuration.ConfigurationProperty("", Options=System.Configuration.ConfigurationPropertyOptions.IsDefaultCollection)]
public System.Configuration.ConnectionStringSettingsCollection ConnectionStrings { get; }
public System.Configuration.ConnectionStringSettingsCollection ConnectionStrings { get; }
[<System.Configuration.ConfigurationProperty("", Options=System.Configuration.ConfigurationPropertyOptions.IsDefaultCollection)>]
member this.ConnectionStrings : System.Configuration.ConnectionStringSettingsCollection
member this.ConnectionStrings : System.Configuration.ConnectionStringSettingsCollection
Public ReadOnly Property ConnectionStrings As ConnectionStringSettingsCollection

Property Value

A ConnectionStringSettingsCollection collection of ConnectionStringSettings objects.

Attributes

Examples

The following example shows how to use the ConnectionStrings property of the ConnectionStringsSection object.

static void ShowConnectionStrings()
{
    // Get the application configuration file.
    System.Configuration.Configuration config =
            ConfigurationManager.OpenExeConfiguration(
            ConfigurationUserLevel.None);

    // Get the connectionStrings section.
    ConnectionStringsSection csSection =
        config.ConnectionStrings;

    for (int i = 0; i <
        ConfigurationManager.ConnectionStrings.Count; i++)
    {
        ConnectionStringSettings cs =
            csSection.ConnectionStrings[i];

        Console.WriteLine($"  Connection String: \"{cs.ConnectionString}\"");

        Console.WriteLine($"#{i}");
        Console.WriteLine($"  Name: {cs.Name}");

        Console.WriteLine($"  Provider Name: {cs.ProviderName}");
    }
}
Shared Sub ShowConnectionStrings() 

    ' Get the application configuration file.
    Dim config _
    As System.Configuration.Configuration = _
    ConfigurationManager.OpenExeConfiguration( _
    ConfigurationUserLevel.None)

    ' Get the conectionStrings section.
    Dim csSection _
    As ConnectionStringsSection = _
    config.ConnectionStrings
    
    For i As Integer = 0 To ConfigurationManager.ConnectionStrings.Count - 1
        Dim cs As ConnectionStringSettings = _
        csSection.ConnectionStrings(i)
        
        Console.WriteLine( _
        "  Connection String: ""{0}""", cs.ConnectionString)
        Console.WriteLine("#{0}", i)
        Console.WriteLine("  Name: {0}", cs.Name)
        
        Console.WriteLine( _
        "  Provider Name: {0}", cs.ProviderName)

    Next i

End Sub

Applies to

See also