How to change or set connection string directly in app.config file in C#

Question

0.00/5 (No votes)

See more:

If i misplace my database file to another folder then i want to change the connection string path. then how to change the connection string at run time.

What I have tried:

I have to put this type of functionality in my desktop application.

Posted 16-Apr-18 2:39am

Member 11776570

Updated 16-Apr-18 3:28am

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2018-04-16T02:47:00

This is more than you are asking for, but have a look here: Instance Storage - A Simple Way to Share Configuration Data among Applications[^]
I have a number of apps which connect to the same SQL instance via different databases, and this code lets me change the SQL server connection string in one place and it seamlessly works for all the apps using the code.

RickZeeland · Answer 2 · 2018-04-16T03:29:00

Solution 2

Your app.config file will be renamed to appname.exe.config when built, you can edit this file with a text editor or use methods like:

Properties.Settings.Default.FirstUserSetting = "abc";

More information here: Managing Application Settings (.NET)[^]

Posted 16-Apr-18 3:29am

RickZeeland

Comments

Member 11776570 19-Apr-18 5:26am

But i have to change from app.config file. this is not working.

RickZeeland 19-Apr-18 5:55am

After you have built you application there will not be an app.config file, it will have the application name like this: appname.exe.config.
You can edit this file, if your app is running you will have to restart it for the changes to take effect.
In settings also make sure you select Application and not User settings otherwise your config file will be hard to find ...

Member 11776570 19-Apr-18 8:18am

Ok. I had done. Problem is solved. ty u for your feedback.