ConnectionStringSettingsCollection.Remove Method
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Removes a ConnectionStringSettings object from the collection.
Overloads
| Remove(ConnectionStringSettings) |
Removes the specified ConnectionStringSettings object from the collection. |
| Remove(String) |
Removes the specified ConnectionStringSettings object from the collection. |
Remove(ConnectionStringSettings)
Removes the specified ConnectionStringSettings object from the collection.
public:
void Remove(System::Configuration::ConnectionStringSettings ^ settings);public void Remove (System.Configuration.ConnectionStringSettings settings);member this.Remove : System.Configuration.ConnectionStringSettings -> unitPublic Sub Remove (settings As ConnectionStringSettings)Parameters
- settings
- ConnectionStringSettings
A ConnectionStringSettings object in the collection.
Examples
The following example shows how to remove the specified ConnectionStringSettings object from the collection.
static void RemoveConnectionStrings()
{
try
{
System.Configuration.Configuration config =
ConfigurationManager.OpenExeConfiguration(
ConfigurationUserLevel.None);
// Clear the connection strings collection.
ConnectionStringsSection csSection =
config.ConnectionStrings;
ConnectionStringSettingsCollection csCollection =
csSection.ConnectionStrings;
// Get the connection string setting element
// with the specified name.
ConnectionStringSettings cs =
csCollection["ConnStr0"];
// Remove it.
if (cs != null)
{
// Remove the element.
csCollection.Remove(cs);
// Save the configuration file.
config.Save(ConfigurationSaveMode.Modified);
Console.WriteLine(
"Connection string settings removed.");
}
else
Console.WriteLine(
"Connection string settings does not exist.");
}
catch (ConfigurationErrorsException err)
{
Console.WriteLine(err.ToString());
}
}
Shared Sub RemoveConnectionStrings()
Try
' Get the application configuration file.
Dim config _
As System.Configuration.Configuration = _
ConfigurationManager.OpenExeConfiguration( _
ConfigurationUserLevel.None)
' Clear the connection strings collection.
Dim csSection _
As ConnectionStringsSection = _
config.ConnectionStrings
Dim csCollection _
As ConnectionStringSettingsCollection = _
csSection.ConnectionStrings
' Get the connection string setting element
' with the specified name.
Dim cs As ConnectionStringSettings = _
csCollection("ConnStr0")
' Remove it.
If Not (cs Is Nothing) Then
' Remove the element.
csCollection.Remove(cs)
' Save the configuration file.
config.Save(ConfigurationSaveMode.Modified)
Console.WriteLine( _
"Connection string settings removed.")
Else
Console.WriteLine( _
"Connection string settings does not exist.")
End If
Catch err As ConfigurationErrorsException
Console.WriteLine(err.ToString())
End Try
End Sub
See also
Applies to
Remove(String)
Removes the specified ConnectionStringSettings object from the collection.
public:
void Remove(System::String ^ name);public void Remove (string name);member this.Remove : string -> unitPublic Sub Remove (name As String)Parameters
- name
- String
The name of a ConnectionStringSettings object in the collection.
Examples
The following example shows how to remove the ConnectionStringSettings object with the specified name from the collection.
static void RemoveConnectionStrings2()
{
try
{
System.Configuration.Configuration config =
ConfigurationManager.OpenExeConfiguration(
ConfigurationUserLevel.None);
// Clear the connection strings collection.
ConnectionStringsSection csSection =
config.ConnectionStrings;
ConnectionStringSettingsCollection csCollection =
csSection.ConnectionStrings;
// Remove the element.
csCollection.Remove("ConnStr0");
// Save the configuration file.
config.Save(ConfigurationSaveMode.Modified);
Console.WriteLine(
"Connection string settings removed.");
}
catch (ConfigurationErrorsException err)
{
Console.WriteLine(err.ToString());
}
}
Shared Sub RemoveConnectionStrings2()
Try
' Get the application configuration file.
Dim config _
As System.Configuration.Configuration = _
ConfigurationManager.OpenExeConfiguration( _
ConfigurationUserLevel.None)
' Clear the connection strings collection.
Dim csSection _
As ConnectionStringsSection = _
config.ConnectionStrings
Dim csCollection _
As ConnectionStringSettingsCollection = _
csSection.ConnectionStrings
' Remove the element.
csCollection.Remove("ConnStr0")
' Save the configuration file.
config.Save(ConfigurationSaveMode.Modified)
Console.WriteLine( _
"Connection string settings removed.")
Catch err As ConfigurationErrorsException
Console.WriteLine(err.ToString())
End Try
End Sub
See also
Applies to
Collaborer avec nous sur GitHub
La source de ce contenu se trouve sur GitHub, où vous pouvez également créer et examiner les problèmes et les demandes de tirage. Pour plus d’informations, consultez notre guide du contributeur.
