C# 4.0 WinForms Development in 3 tier

Question

2.00/5 (1 vote)

See more:

, +

Hi all,
I understand that its always good practice to keep the connection string in app.config file.
Here, i have 2 doubts:-
1. In my user login screen,
user is selecting the Database Name from a combo box.
So how to keep the selected database name as part of the connection string in the app.config file.
What is the best solution to my problem?..

2. If user also enter the Database passsword also (not the user pwd for login authentication),
how to attach it to app.config duly encrypted?

hope someone can guide me..
thanks
Jim

Posted 16-Sep-13 2:40am

jim1972

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-09-16T05:13:00

Solution 1

A config file can contain many connection strings - all you need is a separate setting for each, or a single setting, and concatenation characters. You can then split the separate settings using the string.Split method.
One way to do it would be to store your strings as:

NameOfConnection:ConnectionString|NameOfConnection:ConnectionString|...

You can then split the string on '|', and break the result into a name / value pair on the first ':'

Posted 16-Sep-13 5:13am

OriginalGriff

Comments

jim1972 16-Sep-13 20:21pm

I still think this wont solve my problem.
My case is this is going to be used in a system where i don't know the server name and
database name. also this may be installed in many places.
In that case, if end user gives server name and db name as user input, how to achieve the result?. any better alternative?..

OriginalGriff 17-Sep-13 4:03am

Why won't this work? Is there anything in the rule book which says "I must not alter values in app.config" - because if there was, there would be 1) no point in having application configuration files, and 2) a lot of programs that don't work any more...