WebConfigurationManager.ConnectionStrings Property

 

Gets the Web site's connection strings.

Namespace:   System.Web.Configuration
Assembly:  System.Web (in System.Web.dll)

public static ConnectionStringSettingsCollection ConnectionStrings { get; }

Property Value

Type: System.Configuration.ConnectionStringSettingsCollection

A ConnectionStringSettingsCollection object that contains the contents of the ConnectionStringsSection object for the current Web application's default configuration.

Exception Condition
ConfigurationErrorsException

A valid ConnectionStringSettingsCollection object could not be retrieved.

The following example shows how to use the ConnectionStrings property to access configuration information and enumerate the results. To access a specific connection string, use the returned ConnectionStringSettingsCollection with the name of the desired connection string as an indexer.


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

.NET Framework
Available since 2.0
Return to top
Show: