DbConnectionStringBuilder.ContainsKey Method
.NET Framework 3.0
Determines whether the DbConnectionStringBuilder contains a specific key.
Namespace: System.Data.Common
Assembly: System.Data (in system.data.dll)
Assembly: System.Data (in system.data.dll)
public boolean ContainsKey ( String keyword )
public function ContainsKey ( keyword : String ) : boolean
Not applicable.
Parameters
- keyword
The key to locate in the DbConnectionStringBuilder.
Return Value
true if the DbConnectionStringBuilder contains an entry with the specified key; otherwise false.static void Main() { DbConnectionStringBuilder builder = new DbConnectionStringBuilder(); builder.Add("Provider", "Provider=Microsoft.Jet.OLEDB.4.0"); builder.Add("Data Source", "C:\\ThisExcelWorkbook.xls"); builder.Add("Extended Properties", "Excel 8.0;HDR=Yes;IMEX=1"); // Displays the values in the DbConnectionStringBuilder. Console.WriteLine("Contents of the DbConnectionStringBuilder:"); Console.WriteLine(builder.ConnectionString); // Searches for a key. if (builder.ContainsKey("Data Source")) { Console.WriteLine("The collection contains the key \"Data Source\"."); } else { Console.WriteLine("The collection does not contain the key \"Data Source\"."); } Console.ReadLine(); }
This code produces the following output:
Contents of the DbConnectionStringBuilder: provider="Provider=Microsoft.Jet.OLEDB.4.0";data source=C:\MyExcel.xls;extended properties="Excel 8.0;HDR=Yes;IMEX=1" The collection contains the key "Data Source".
Windows 98, Windows Server 2000 SP4, Windows Millennium Edition, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition
The Microsoft .NET Framework 3.0 is supported on Windows Vista, Microsoft Windows XP SP2, and Windows Server 2003 SP1.