using System.Data.SqlClient; SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder(); builder.DataSource = "localhost"; builder.InitialCatalog = "MyDatabase"; builder.UserID = "MyUsername"; builder.Password = "MyPassword"; string connectionString = builder.ConnectionString;
using System.Data.SqlClient; string connectionString = "Data Source=localhost;Initial Catalog=MyDatabase;User ID=MyUsername;Password=MyPassword;"; SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder(connectionString); string dataSource = builder.DataSource; string initialCatalog = builder.InitialCatalog; string userID = builder.UserID; string password = builder.Password;In this example, we create a SqlConnectionStringBuilder instance by passing an existing connection string to its constructor. We then retrieve the individual parameter values using the relevant properties. Package/Library: System.Data.SqlClient