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 -> unit
Public 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 -> unit
Public 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
反馈
https://aka.ms/ContentUserFeedback。
即将发布:在整个 2024 年,我们将逐步淘汰作为内容反馈机制的“GitHub 问题”,并将其取代为新的反馈系统。 有关详细信息,请参阅:提交和查看相关反馈