Ask for sql server name and password, ask again if changed

Question

4.00/5 (1 vote)

See more:

Hi.. Friends I have a window based project in vb.net and SQL 2005 my requirement is that I want to make it fully dynamically means, when first user use it he set the sql server name or password for the application only first time. After that if sql server name has been changed then it ask again to the user who first of all use the application after change the server name or password. Please help how can i get it.

Thanks in advance

Parveen Rathi

Posted 21-Nov-11 2:46am

Parveen Rathi

Updated 21-Nov-11 2:47am

v2

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)

VallarasuS · Answer 1 · 2011-11-21T03:27:00

If you have change notification function then it must be easy to implement, or else possibly if log in fails you can prompt for the credentials again.

Just persist the value on Registry or as a file, and make use of it each time a login is required, and when it fails on a try just prompt for it and over write the persisted values.

this is just a way of doing it, modify it as needed and have fun.

C#

private void LogTheUserIn()
{
    /*
     * that includes uid, pwd, possibly connection string
     * here i proceed with the persisted values
     * not prompting from the user.
     */
    string credentials = GetPersistedCredentials();

    bool loginFailed = TryConnectToServer(credentials);

    /* there are many possibilities it may fail, I assume its coz of credentials */
    if (loginFailed)
    {
        credentials = PromptForCredentials();
        OverWritePersistedCredentials(credentials);

        /*
         * log in with the new credentials.
         * Be sure to avoid recursion.
         */
        LogTheUserIn();
    }
}

Hope it helps.