If I use two connection strings in our web.config file then in C# how can we find which connection in first time

Question

4.00/5 (1 vote)

See more:

Suppose I provide two connection strings web.config then how can we recognize which connection was open in C#

By the code:

myconnection.open();
myconnection.close();

How to open particular connection

Abhishek Sur
Thanks for help but plz provide little examle in c#
how connect connection first connection
after that
connection to second connection

Wating reply.....

Posted 1-Feb-10 20:24pm

Ganesh_verma

Updated 3-Feb-10 0:03am

v3

Add a Solution

4 solutions

Solution 4

Ganesh_verma wrote:
Thanks for help but plz provide little examle in c#

It's not our fault that you are stupid. Every answer you have is correct, they just assume a very basic level of competence. You need to write your code to address your connection strings by name or by index, then write the code to make the right calls to each DB, based on the two connection strings. A more specific example both should not be needed, and is impossible without seeing your config file.

Posted 3-Feb-10 0:05am

Christian Graus

Solution 1

If you have two connection strings, you'd have to specify in your code which one you were using. It isn't going to magically choose one or the other if they are named the same thing, it's going to give an error. If they are not named the same, you'll access them by name.

Posted 1-Feb-10 21:29pm

Christian Graus

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)

leckey · Accepted Answer · 2010-02-02T14:57:00

Solution 3

You can run the code (in C#):
string
strConn=ConfigurationSettings.AppSettings["ConnectionString"];

Posted 2-Feb-10 14:57pm

leckey

Abhishek Sur · Accepted Answer · 2010-02-02T12:02:00

Solution 2

Name each connectionstring and call it by name.

ConfigurationManager.ConnectionStrings["con1"].ConnectionString

like this.

If you still want the index based connectionstring, it will call according to the sequence mentioned in the web.config.

Posted 2-Feb-10 12:02pm

Abhishek Sur