Database connection help

Question

5.00/5 (1 vote)

See more:

Hi guys. Hope someone can help me ! I am using C# windows application with a Firebird database. When the program starts you have to log in to the firebird server with a username and password. For certain functions in the program classes get instantiated, and you have to reconnect to the database to execute commands against it. My question is : what will be the best way to save the username and password? in a global variable or is it possible to only connect once to the server for the entire live span of a user log in ?

can anyone please help?

thanks

Posted 27-Jul-11 20:13pm

Gigantour

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)

Amund Gjersøe · Answer 1 · 2011-07-28T01:25:00

Store the username and password using the Settings-functionality in the project-properties window. These are global variables. If you add two user-settings as strings, you automatically store the username and password in a xml-file under the current windows user. To make the password unreadable to the naked eye you can base64-convert the string.

The settings properties are accessed form code like this:

C#

// Saving the username. Saved as "QW11bmQ="
string userName = "Amund";
byte[] bytearray = Encoding.Default.GetBytes(userName);
string userName64 = Convert.ToBase64String(bytearray);
Properties.Settings.Default.UserName = userName64;
Properties.Settings.Default.Save();

// Loading the username from settings at application start-up
string _userName;
string userName64 = Properties.Settings.Default.UserName;
if(!userName64.Equals(String.Empty))
    _userName = Encoding.Default.GetString(Convert.FromBase64String(userName64));