ConnectionStringSettingsCollection.Add(ConnectionStringSettings) Method

Definition

Namespace:

System.Configuration

Assembly:

System.Configuration.ConfigurationManager.dll

Adds a ConnectionStringSettings object to the collection.

public:
 void Add(System::Configuration::ConnectionStringSettings ^ settings);

public void Add (System.Configuration.ConnectionStringSettings settings);

member this.Add : System.Configuration.ConnectionStringSettings -> unit

Public Sub Add (settings As ConnectionStringSettings)

Parameters

settings

ConnectionStringSettings

A ConnectionStringSettings object to add to the collection.

Examples

The following example shows how to add a ConnectionStringSettings object to a ConnectionStringSettingsCollection collection.

// Add a connection string to the connection
// strings section and store it in the
// configuration file.
static void AddConnectionStrings()
{

    // Get the count of the connection strings.
    int connStrCnt =
        ConfigurationManager.ConnectionStrings.Count;

    // Define the string name.
    string csName = "ConnStr" +
        connStrCnt.ToString();

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

    // Add the connection string.
    ConnectionStringsSection csSection =
        config.ConnectionStrings;
    csSection.ConnectionStrings.Add(
        new ConnectionStringSettings(csName,
            "LocalSqlServer: data source=127.0.0.1;Integrated Security=True;" +
            "Initial Catalog=aspnetdb", "System.Data.SqlClient"));

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

    Console.WriteLine("Connection string added.");
}

' Add a connection string to the connection
' strings section and store it in the
' configuration file.
Shared Sub AddConnectionStrings() 
    
    ' Get the count of the connection strings.
    Dim connStrCnt As Integer = _
    ConfigurationManager.ConnectionStrings.Count
    
    ' Define the string name.
    Dim csName As String = _
    "ConnStr" + connStrCnt.ToString()
    
    ' Get the configuration file.
    Dim config _
    As System.Configuration.Configuration = _
    ConfigurationManager.OpenExeConfiguration( _
    ConfigurationUserLevel.None)
    
    ' Add the connection string.
    Dim csSection _
    As ConnectionStringsSection = _
    config.ConnectionStrings
    csSection.ConnectionStrings.Add( _
    New ConnectionStringSettings(csName, _
    "LocalSqlServer: data source=127.0.0.1;Integrated Security=SSPI;" _
    + "Initial Catalog=aspnetdb", "System.Data.SqlClient"))

    ' Save the configuration file.
    config.Save(ConfigurationSaveMode.Modified)
    
    Console.WriteLine("Connection string added.")

End Sub

See also

• ConnectionStringsSection