ConnectionStringsSection Class

Definition

public ref class ConnectionStringsSection sealed : System::Configuration::ConfigurationSection

public sealed class ConnectionStringsSection : System.Configuration.ConfigurationSection

type ConnectionStringsSection = class
    inherit ConfigurationSection

Public NotInheritable Class ConnectionStringsSection
Inherits ConfigurationSection

Inheritance

Object

ConfigurationElement

ConfigurationSection

ConnectionStringsSection

Examples

The following example shows how to use the ConnectionStringsSection.

       // Create a connectionn string element and add it to
       // the connection strings section.
       static ConnectionStrings()
       {
           // Get the application configuration file.
           System.Configuration.Configuration config =
                   ConfigurationManager.OpenExeConfiguration(
                   ConfigurationUserLevel.None);

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

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

           // Create a connection string element and
           // save it to the configuration file.
          
           // Create a connection string element.
           ConnectionStringSettings csSettings =
                   new ConnectionStringSettings(csName,
                   "LocalSqlServer: data source=127.0.0.1;Integrated Security=SSPI;" +
                   "Initial Catalog=aspnetdb", "System.Data.SqlClient");

           // Get the connection strings section.
           ConnectionStringsSection csSection =
               config.ConnectionStrings;

           // Add the new element.
           csSection.ConnectionStrings.Add(csSettings);
               
           // Save the configuration file.
           config.Save(ConfigurationSaveMode.Modified);
       }

' Create a connectionn string element and add it to
' the connection strings section.
Shared Sub New() 

    ' Get the application configuration file.
    Dim config _
    As System.Configuration.Configuration = _
    ConfigurationManager.OpenExeConfiguration( _
    ConfigurationUserLevel.None)
    
    ' Get the current connection strings count.
    Dim connStrCnt As Integer = _
    ConfigurationManager.ConnectionStrings.Count
    
    ' Create the connection string name. 
    Dim csName As String = "ConnStr" + connStrCnt.ToString()
    
    ' Create a connection string element and
    ' save it to the configuration file.
    ' Create a connection string element.
    Dim csSettings _
    As New ConnectionStringSettings( _
    csName, _
    "LocalSqlServer: data source=127.0.0.1;Integrated Security=SSPI;" + _
    "Initial Catalog=aspnetdb", "System.Data.SqlClient")
    
    ' Get the connection strings section.
    Dim csSection _
    As ConnectionStringsSection = _
    config.ConnectionStrings
    
    ' Add the new element.
    csSection.ConnectionStrings.Add(csSettings)
    
    ' Save the configuration file.
    config.Save(ConfigurationSaveMode.Modified)

End Sub
 

The following excerpt shows the configuration used by the previous example.

<?xml version="1.0" encoding="utf-8"?>  
<configuration>  
  <connectionStrings>  
    <add name="ConnStr1" connectionString="LocalSqlServer: data source=127.0.0.1;Integrated Security=SSPI;Initial Catalog=aspnetdb"  
      providerName="System.Data.SqlClient" />  
  </connectionStrings>  
</configuration>  

Remarks

The ConnectionStringsSection class allows you to programmatically modify the connectionStrings section of the configuration file. The connection strings are provided as a ConnectionStringSettingsCollection of ConnectionStringSettingsadd configuration elements.

Constructors

Properties

Methods

Applies to

See also

• ConnectionStringSettingsCollection
• ConnectionStringSettings