How to

parse connection string

Home » Databases » How to parse connection string

Published: 22. December 2008 | Updated: 22. December 2008
License: Microsoft Public License (MS-PL)
Categories: Databases
Tags: C# SQL Text

Was this snippet helpful for you?

YES /

Import namespace

using System.Data.SqlClient;

Code

SqlConnectionStringBuilder builder = null;
builder = new SqlConnectionStringBuilder(@"Server=.\SQLEXPRESS;Database=web;" +
        "Trusted_Connection=no;MultipleActiveResultSets=true;Uid=user;Pwd=d4A6x0z5");

Console.WriteLine("Data Source: {0}", builder.DataSource);
Console.WriteLine("Initial Catalog: {0}", builder.InitialCatalog);
Console.WriteLine("User ID: {0}", builder.UserID);
Console.WriteLine("Password: {0}", builder.Password);