how i can get connection string of db on host computer??

Question

as my code is dependent on the database so whenever i take my code on the different computer, i need to set connection string for it and recompile the project.. can i get this string by using any api.. at run time ? i don't want to give it string every time when i change pc or database server..

Answer 1

You can store it in the .config file

Answer 2

if i have it.. then why should i store it any where... the problem is that i don't know when i change my computer...

Answer 3

If the database resides on the same computer then nothing should change; unless you change the name of the database, of course (you are always on the local server). If it's a remote database then you should program in a way for the user to select the database.

The simplest way, as stated, is to store it in a config file. You have to store it somewhere. It may be we are confused b what you are asking: try giving a simple example scenario.