Dynamic Connection string

Question

Hi..
Do consider my thought. I want to write my connection string in such away that it fits in the environment of database back up and restore. i.e. Most of time we do use hardcoded connection string. But if the user restores the backed up database to some other drive due to some reason or changes the restored database file name to his will, our whole program will crash. So, I invite some thoughts & lights on whether we could write the connection sting in such a way that it'll fit into these environment or suggest possible logic. Thanks in advance.

Kirtan Patel · Answer

you can store Connection String in XML File from where your application should read the Connection string .. if user want that he want to load his own database named files then user Opens that XML File and Modify according to his preference..or if you automate this task too then provide form that will allow user to enter his own settings for database name .. file path etc ..