Click to Rate and Give Feedback
MSDN
MSDN Library
.NET Development
Previous Versions
.NET Framework 3.0
Class Library
 ConnectionStrings Property
This page is specific to
.NET Framework 3.0

Other versions are also available for the following:
ConnectionStringsSection.ConnectionStrings Property
Gets a ConnectionStringSettingsCollection collection of ConnectionStringSettings objects.

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

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.

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);
        
    }

}

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.

.NET Framework

Supported in: 3.0, 2.0
Tags What's this?: Add a tag
Community Content   What is Community Content?
Add new content      
Processing
© 2008 Microsoft Corporation. All rights reserved. Terms of Use  |  Trademarks  |  Privacy Statement
Page view tracker