WebConfigurationManager.ConnectionStrings Propriedade

  • Referência

Definição

Namespace:
System.Web.Configuration
Assembly:
System.Web.dll

Obtém as cadeias de conexão do site da Web.

public:
 static property System::Configuration::ConnectionStringSettingsCollection ^ ConnectionStrings { System::Configuration::ConnectionStringSettingsCollection ^ get(); };
public static System.Configuration.ConnectionStringSettingsCollection ConnectionStrings { get; }
member this.ConnectionStrings : System.Configuration.ConnectionStringSettingsCollection
Public Shared ReadOnly Property ConnectionStrings As ConnectionStringSettingsCollection

Valor da propriedade

ConnectionStringSettingsCollection

Um objeto ConnectionStringSettingsCollection que contém o conteúdo do objeto ConnectionStringsSection para a configuração padrão do aplicativo Web.

Exceções

ConfigurationErrorsException

Não foi possível recuperar um objeto ConnectionStringSettingsCollection válido.

Exemplos

O exemplo a seguir mostra como usar a ConnectionStrings propriedade para acessar informações de configuração e enumerar os resultados. Para acessar uma cadeia de conexão específica, use o retornado ConnectionStringSettingsCollection com o nome da cadeia de conexão desejada como indexador.


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

' Show the use of ConnectionStrings property
' to get the connection strings. 
Shared Sub GetConnectionStrings()
   
   ' Get the connectionStrings key,value pairs collection.
     Dim connectionStrings As ConnectionStringSettingsCollection = _
     WebConfigurationManager.ConnectionStrings
   
   ' Get the collection enumerator.
     Dim connectionStringsEnum As IEnumerator = _
     connectionStrings.GetEnumerator()
   
   ' Loop through the collection and 
   ' display the connectionStrings key, value pairs.
   Dim i As Integer = 0
   Console.WriteLine("[Display connectionStrings]")
   While connectionStringsEnum.MoveNext()
      Dim name As String = connectionStrings(i).Name
         Console.WriteLine("Name: {0} Value: {1}", _
         name, connectionStrings(name))
      i += 1
   End While
   
   Console.WriteLine()
End Sub

Aplica-se a

Confira também