OdbcConnectionStringBuilder.Remove(String) 方法
定義
重要
部分資訊涉及發行前產品,在發行之前可能會有大幅修改。 Microsoft 對此處提供的資訊,不做任何明確或隱含的瑕疵擔保。
從實例中移除指定金鑰 OdbcConnectionStringBuilder 的條目。
public:
override bool Remove(System::String ^ keyword);
public override bool Remove(string keyword);
override this.Remove : string -> bool
Public Overrides Function Remove (keyword As String) As Boolean
參數
- keyword
- String
在此 OdbcConnectionStringBuilder 中,要從連接字串中移除的鍵/值對的鍵。
傳回
true 若金鑰存在於連接字串中且已被移除;false 若金鑰不存在。
例外狀況
keyword 在 Visual Basic 中為空Nothing 。
範例
以下範例建立一個 OdbcConnectionStringBuilder 實例並展示該 Remove 方法的行為。
using System.Data.Odbc;
class Program
{
static void Main()
{
OdbcConnectionStringBuilder builder =
new OdbcConnectionStringBuilder();
builder.ConnectionString =
"Driver={SQL Server};Server=(local);" +
"Database=AdventureWorks;Trusted_Connection=yes;";
Console.WriteLine(builder.ConnectionString);
// Try to remove an existing item.
TryRemove(builder, "Server");
// Try to remove a nonexistent item.
TryRemove(builder, "User ID");
// Try to remove an existing item,
// demonstrating that the search is not
// case sensitive.
TryRemove(builder, "DATABASE");
Console.WriteLine("Press Enter to continue.");
Console.ReadLine();
}
static void TryRemove(OdbcConnectionStringBuilder builder,
string itemToRemove)
{
if (builder.Remove(itemToRemove))
{
Console.WriteLine("Removed '{0}'", itemToRemove);
}
else
{
Console.WriteLine("Unable to remove '{0}'", itemToRemove);
}
Console.WriteLine(builder.ConnectionString);
}
}
Imports System.Data.Odbc
Module Module1
Sub Main()
Dim builder As New OdbcConnectionStringBuilder
builder.ConnectionString = _
"Driver={SQL Server};Server=(local);" & _
"Database=AdventureWorks;Trusted_Connection=yes;"
Console.WriteLine(builder.ConnectionString)
' Try to remove an existing item.
TryRemove(builder, "Server")
' Try to remove a nonexistent item.
TryRemove(builder, "User ID")
' Try to remove an existing item,
' demonstrating that the search is not
' case sensitive.
TryRemove(builder, "DATABASE")
Console.WriteLine("Press Enter to continue.")
Console.ReadLine()
End Sub
Sub TryRemove(ByVal builder As OdbcConnectionStringBuilder, _
ByVal itemToRemove As String)
If builder.Remove(itemToRemove) Then
Console.WriteLine("Removed '{0}'", itemToRemove)
Else
Console.WriteLine("Unable to remove '{0}'", itemToRemove)
End If
Console.WriteLine(builder.ConnectionString)
End Sub
End Module
備註
由於 Remove 方法回傳的值顯示其成功,因此在嘗試移除該鍵值對 OdbcConnectionStringBuilder 之前,不需要先尋找金鑰的存在。