public ref class ConnectionStringSettingsCollection sealed : System::Configuration::ConfigurationElementCollection
[System.Configuration.ConfigurationCollection(typeof(System.Configuration.ConnectionStringSettings))]
public sealed class ConnectionStringSettingsCollection : System.Configuration.ConfigurationElementCollection
[<System.Configuration.ConfigurationCollection(typeof(System.Configuration.ConnectionStringSettings))>]
type ConnectionStringSettingsCollection = class
inherit ConfigurationElementCollection
Public NotInheritable Class ConnectionStringSettingsCollection
Inherits ConfigurationElementCollection
static void ShowConnectionStrings()
{
// Get the application configuration file.
System.Configuration.Configuration config =
ConfigurationManager.OpenExeConfiguration(
ConfigurationUserLevel.None);
// Get the connectionStrings section.
ConnectionStringsSection csSection =
config.ConnectionStrings;
for (int i = 0; i <
ConfigurationManager.ConnectionStrings.Count; i++)
{
ConnectionStringSettings cs =
csSection.ConnectionStrings[i];
Console.WriteLine($" Connection String: \"{cs.ConnectionString}\"");
Console.WriteLine($"#{i}");
Console.WriteLine($" Name: {cs.Name}");
Console.WriteLine($" Provider Name: {cs.ProviderName}");
}
}
Shared Sub ShowConnectionStrings()
' Get the application configuration file.
Dim config _
As System.Configuration.Configuration = _
ConfigurationManager.OpenExeConfiguration( _
ConfigurationUserLevel.None)
' Get the conectionStrings section.
Dim csSection _
As ConnectionStringsSection = _
config.ConnectionStrings
For i As Integer = 0 To ConfigurationManager.ConnectionStrings.Count - 1
Dim cs As ConnectionStringSettings = _
csSection.ConnectionStrings(i)
Console.WriteLine( _
" Connection String: ""{0}""", cs.ConnectionString)
Console.WriteLine("#{0}", i)
Console.WriteLine(" Name: {0}", cs.Name)
Console.WriteLine( _
" Provider Name: {0}", cs.ProviderName)
Next i
End Sub
