ConnectionStringsSection.ConnectionStrings Property
Gets a ConnectionStringSettingsCollection collection of ConnectionStringSettings objects.

Namespace: System.Configuration
Assembly: System.Configuration (in system.configuration.dll)

Syntax

Visual Basic (Declaration)
Public ReadOnly Property ConnectionStrings As ConnectionStringSettingsCollection
Visual Basic (Usage)
Dim instance As ConnectionStringsSection
Dim value As ConnectionStringSettingsCollection

value = instance.ConnectionStrings
C#
public ConnectionStringSettingsCollection ConnectionStrings { get; }
C++
public:
property ConnectionStringSettingsCollection^ ConnectionStrings {
    ConnectionStringSettingsCollection^ get ();
}
J#
/** @property */
public ConnectionStringSettingsCollection get_ConnectionStrings ()
JScript
public function get ConnectionStrings () : ConnectionStringSettingsCollection
XAML
Not applicable.

Property Value

A ConnectionStringSettingsCollection collection of ConnectionStringSettings objects.
Example

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

Visual Basic
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
    
    Dim i As Integer
    For i = 0 To ConfigurationManager.ConnectionStrings.Count
        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 'ShowConnectionStrings
C#
static void ShowConnectionStrings()
{
     // Get the application configuration file.
    System.Configuration.Configuration config =
            ConfigurationManager.OpenExeConfiguration(
            ConfigurationUserLevel.None);

    // Get the conectionStrings section.
    ConnectionStringsSection csSection =
        config.ConnectionStrings;
    
    for (int i = 0; i < 
        ConfigurationManager.ConnectionStrings.Count; i++)
    {
        ConnectionStringSettings cs = 
            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);
        
    }

}
Platforms

Windows 98, Windows Server 2000 SP4, Windows Millennium Edition, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition

The Microsoft .NET Framework 3.0 is supported on Windows Vista, Microsoft Windows XP SP2, and Windows Server 2003 SP1.

Version Information

.NET Framework

Supported in: 3.0, 2.0
See Also

Tags :


Page view tracker