SqlConnectionStringBuilder.Keys Property
.NET Framework 4
Gets an ICollection that contains the keys in the SqlConnectionStringBuilder.
Assembly: System.Data (in System.Data.dll)
Property Value
Type: System.Collections.ICollectionAn ICollection that contains the keys in the SqlConnectionStringBuilder.
Implements
IDictionary.KeysThe order of the values in the ICollection is unspecified, but it is the same order as the associated values in the ICollection returned by the Values property.
The following console application example creates a new SqlConnectionStringBuilder. The code loops through the ICollection returned by the Keys property displaying the key/value pairs.
using System.Data.SqlClient; class Program { static void Main() { SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder(); builder.DataSource = "(local)"; builder.IntegratedSecurity = true; builder.InitialCatalog = "AdventureWorks"; // Loop through the collection of keys, displaying // the key and value for each item: foreach (string key in builder.Keys) Console.WriteLine("{0}={1}", key, builder[key]); Console.WriteLine(); Console.WriteLine("Press Enter to continue."); Console.ReadLine(); } }
Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows XP SP2 x64 Edition, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2
The .NET Framework does not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.
