how to find connection string sql server via code not by properties

Question

Can someone help me out?

Whenever I switch computers I have to copy the connection string again. I don't want to do that. Is there any alternative method for finding it? I am using Visual Studio 2013 and C#.

I have kept the application in a flash drive so I may use it on any computer. But it only works on my computer.

con = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=H:\DataBaseApp\DataBaseApp\DB.mdf;Integrated Security=True"); 
con.Open();

This is what I'm using but I would appreciate if someone tells me how not to use this.

Does your flash drive always get mounted as the H: drive on all the computers you're using this on? — marc_s
– marc_s, Commented Sep 12, 2014 at 20:46

mybirthname · Accepted Answer · 2014-09-12 20:58:34Z

0

1) Create connection string property

2) Add connection string to web config. DataSource should be some alias like TestDataBase.

3) Fill the connection string property from web config value.

4) Add Sql Alias on the current PC with name TestDataBase.

When you go to another PC you should only configure new SQL Alias.

In this case multiple users can work without changes in the code(Example source control).

edited Sep 12, 2014 at 20:58

answered Sep 12, 2014 at 20:50

mybirthname

18.2k3 gold badges35 silver badges59 bronze badges

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

Comments

Shell · Accepted Answer · 2014-09-13 09:59:06Z

0

You can save your connection string in any text file, for example: conn.txt and put it in bin\Debug folder. Now, you can read it at runtime by using this code.

string path = Path.Combine(Application.StartupPath, "conn.txt");
string connStrg = System.IO.File.ReadAllText(path);
using (SqlConnection cnn = new SqlConnection(connStrg))
{
    ...
}

When you publish your application you need to just create that file where the application is installed. I mean if your application is installed in any specific drive like D:\\MyFolder\\MyApp.exe then your conn.txt file should be created on D:\\MyFolder.

answered Sep 13, 2014 at 9:59

Shell

6,86911 gold badges43 silver badges75 bronze badges

3 Comments

Najam Sahar Over a year ago

but when i will change pc path will also change and again i have to copy the connection string.

Najam Sahar Over a year ago

i want to get the connection string automatically

Shell Over a year ago

hmm.. In that case you need to find out the available sql server. if there're more than one than you need to select only one. You can check this answer to know how to find out the available sql server. Dynamic connection may have different id-password for sql authentication. So, you have to connect the database using Windows Authentication and also it may not possible to connect server without creating named pipe if you are trying to connect network server.

Collectives™ on Stack Overflow

how to find connection string sql server via code not by properties

2 Answers 2

Comments

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related