Dynamically create a database connection for SQL Server

Question

Is there a way of inputting username, password & data source name from user instead of hardcoding them?

Right now I have hardcoded in app.config like this

<connectionStrings>
<add name="SQLConnectionString" connectionString="Data Source=db01\instance01;Initial Catalog=testdb; MultipleActiveResultSets=true;User ID=testuser;Password=readonly; Connection Timeout=60;" providerName="System.Data.SqlClient"/>
</connectionStrings>

When I run the console app, I want it to print how to enter the parameters and then accept parameters. How can I do this?

Thanks Rashmi

You should look into string.Format() function, at least. What have you tried, btw? — Daniel Mošmondor
– Daniel Mošmondor, Commented Mar 3, 2014 at 16:19

Patrick Hofman · Accepted Answer · 2014-03-03 16:20:00Z

1

You can simply create a SqlConnection and set the connection string as first parameter.

string username = Console.ReadLine();

SqlConnection conn = new SqlConnection("User ID=" + username);

Additionally you can take a look at the SqlConnectionStringBuilder that does more for the work for you.

answered Mar 3, 2014 at 16:20

Patrick Hofman

158k23 gold badges270 silver badges343 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Rashmi Over a year ago

sorry, got pulled into another project. Haven't had the time to work on this. Will definitely post my results.

Rashmi Over a year ago

got it to work. Console.WriteLine("Enter DataSource"); stringBuilder.DataSource = Console.ReadLine(); Console.WriteLine("Enter userid"); & so on Console.WriteLine("Generated Connection String = " + stringBuilder.ConnectionString); How can I show "**" when user types in password?

Patrick Hofman Over a year ago

You can't. You can hide input from the user though. See msdn.microsoft.com/en-us/library/x3h8xffw(v=vs.110).aspx

Collectives™ on Stack Overflow

Dynamically create a database connection for SQL Server

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related