-
Notifications
You must be signed in to change notification settings - Fork 260
/
SqlConnectionStringBuilder_UserNamePwd.cs
42 lines (37 loc) · 1.37 KB
/
SqlConnectionStringBuilder_UserNamePwd.cs
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
using System;
using System.Data;
using Microsoft.Data.SqlClient;
using System.Configuration;
class Program
{
static void Main()
{
BuildConnectionString("(local)", "Nate", "somepassword");
Console.ReadLine();
}
// <Snippet1>
private static void BuildConnectionString(string dataSource,
string userName, string userPassword)
{
// Retrieve the partial connection string named databaseConnection
// from the application's app.config or web.config file.
ConnectionStringSettings settings =
ConfigurationManager.ConnectionStrings["partialConnectString"];
if (null != settings)
{
// Retrieve the partial connection string.
string connectString = settings.ConnectionString;
Console.WriteLine("Original: {0}", connectString);
// Create a new SqlConnectionStringBuilder based on the
// partial connection string retrieved from the config file.
SqlConnectionStringBuilder builder =
new SqlConnectionStringBuilder(connectString);
// Supply the additional values.
builder.DataSource = dataSource;
builder.UserID = userName;
builder.Password = userPassword;
Console.WriteLine("Modified: {0}", builder.ConnectionString);
}
}
// </Snippet1>
}