Store database details and call them to Vb form?

Question

0.00/5 (No votes)

See more:

I'm developing with mysql database.

I always declared the details about the database I use at the top of every form. I mean, the database name,username,password and everything about it. We know this will not be great when I deploy my app to other computers. I would like to know the best way to save these credentials and allow someone to set them after installling the app (like how it is done with other apps). May be saving them to a text (.txt) file?

How do I save the details/variables to a text file?
How do I read/call these variables to my forms?

Posted 10-Apr-13 5:01am

savedlema

Add a Solution

1 solution

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 · 2013-04-10T05:20:00

Save them to a config file:
1) Open your projects Properties in the solution explorer, and double click on "Settings.settings"
2) In the resulting grid, change the Name to "ConnectionString", and set the Value to blank. Leave Type and Scope as "string" and "User" respectively.
3) Save and close the settings window.
4) To read your setting:

Dim s as string = Properties.Settings.Default.ConnectionString

5) To write your setting:

Properties.Settings.Default.ConnectionString = "My new setting value"
Properties.Settings.Default.Save()

The connection details will be saved in an XML file that is nice and easy for external programs to edit if necessary.