How to store MySql database connection string in C# WinFrom desktop application

Question

Keeping of MySql connection string with server, user, password and database data seems incorrect inside the code.

I see only two ways, how it can be stored, one is adding into Resources .txt like string data = Properties.Resources.doc;, but I'm not sure if it is secured method, another must be .xml, but I can't find any good guide, how to created such kind of access with .xml correctly, and I'm also not sure if it is most proper way.

Any advice, guide or example would be useful

Steve · Accepted Answer · 2019-04-01 06:53:41Z

3

The standard way to store a connection string in a WinForms application is creating an entry in the connectionStrings section inside the app.Config file.

<configuration>
    <connectionStrings>
         <add name="MyConnection" connectionString="Server=myServer;Database=myDatabase;
                                                    userid=root;password=pass;Port=3306"/>
    </connectionStrings>
    .....
</configuration>

Now you can retrieve this connection string in your code referencing the key named MyConnection using code like this:

string cnnString = ConfigurationManager.ConnectionStrings["MyConnection"].ConnectionString;

It is up to you to decide if you want to retrieve this info every time you need it or store it inside some kind of ad hoc in memory structure like a static MyAppConfig class

edited Apr 1, 2019 at 6:53

answered Mar 31, 2019 at 21:46

Steve

217k22 gold badges242 silver badges296 bronze badges

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

1 Comment

lf80 Over a year ago

Hello, exactly what I was looking for, great support

Collectives™ on Stack Overflow

How to store MySql database connection string in C# WinFrom desktop application

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related