ConnectionStringSettingsCollection.Clear Method

Definition

Namespace:

System.Configuration

Assembly:

System.Configuration.ConfigurationManager.dll

Removes all the ConnectionStringSettings objects from the collection.

public void Clear ();

Examples

The following example shows how to remove all the ConnectionStringSettings objects from the ConnectionStringSettingsCollection collection.

// Clear connection strings collection.
static void ClearConnectionStrings()
{

    // Get the configuration file.
    System.Configuration.Configuration config =
        ConfigurationManager.OpenExeConfiguration(
        ConfigurationUserLevel.None);

    // Clear the connection strings collection.
    ConnectionStringsSection csSection =
        config.ConnectionStrings;
    csSection.ConnectionStrings.Clear();

    // Save the configuration file.
    config.Save(ConfigurationSaveMode.Modified);

    Console.WriteLine("Connection strings cleared.");
}

Remarks

The Clear method removes all the connection strings from the configuration file at the current configuration hierarchy level and writes a <clear> tag in the file. The <clear> tag signifies that all the connection strings defined in the parent configuration files are disregarded by the system.

Applies to

See also

• ConnectionStringsSection