Configuration file in C#

Question

0.00/5 (No votes)

See more:

Hello friends,

I am working in a Window Application but my need is application read database connection from text file . That is working but I want when I publish my Application its also Publish txt file in same folder. Thats why when ever need to change in connection string its by txt file.

ANd When Install this exe then also txt file will be save in local user system.

Posted 15-Apr-13 0:18am

Neetesh Agarwal

Updated 15-Apr-13 0:42am

v2

Add a Solution

Comments

[no name] 15-Apr-13 6:37am

Can you specify your problem again?

Neetesh Agarwal 15-Apr-13 6:42am

My Problem is When client Install my publish Application then There should also be text file.

2 solutions

Solution 1

Hi,

Try This

In that Text file Just put Online DB Name Not Path

Ex:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source= #FilePath# \DB_New.mdb

in code

Read Connstring from txt File and replace

string constring = "";//Read From txt File
string path = Application.ExecutablePath;
string resultPath = path.Substring(0, path.LastIndexOf("\\"));

constring.replace("#FilePath#",resultpath);

Note : It will workout if Your DB Location reside in the same folder of publish EXE File

Thanks

Siva Rm K

Posted 15-Apr-13 0:37am

rmksiva

Comments

Zoltán Zörgő 15-Apr-13 7:12am

MDB??? What has this to do with MySQL?

Neetesh Agarwal 15-Apr-13 7:13am

hello Zoltán Zörgő ,

If u know solution please reply
Thanks

Zoltán Zörgő 15-Apr-13 7:17am

See my answer.

rmksiva 15-Apr-13 8:18am

Thank

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)

**Zoltán Zörgő** · Accepted Answer · 2013-04-15T01:16:00

First of all, be sure to have a proper connection string to your MySQL database (http://connectionstrings.com/mysql[^]).

Forget the text file. More precisely forget your interpretation of a text file, since .NET has the solution out of the box. It is called app.config, and that one has a section just for connection strings. Check here: How to get Connection String from App.Config in c#[^]. You migth find these also useful: Configuring a Connection String in the App.Config File During Runtime in C#[^], http://msdn.microsoft.com/en-us/library/ms171887.aspx[^]

Please note, that the app.config (an XML) is automatically built, and if you include it in your install kit, it is also deployed.

You can even secure the connection strings. Check here: http://msdn.microsoft.com/en-us/library/89211k9b(v=vs.80).aspx[^]