Load connection string depending on Country dropdown List

Question

0.00/5 (No votes)

See more:

Hi Everybody,

My Requirement is in such a way that.
I have a no of connectionstring in web.config which are country wise set.
so when user has logged in depending on his country that no of connection string only to be loaded and not all.

And i suppose this should be only once at the start.

Please suggest me some thing

Thanks and regards

Posted 4-Sep-12 20:40pm

suhailnoorpawane

Add a Solution

2 solutions

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)

Aadhar Joshi · Answer 1 · 2012-09-04T21:17:00

You can use following method:

<br />
System.Configuration.ConfigurationManager.ConnectionStrings["YourConnectionString"].ConnectionString <br />

You could execute select command using a SqlCommand object with the ExecuteReader method,
see: http://msdn.microsoft.com/en-us/library/9kcbe65k.aspx
Look into the other methods available: http://msdn.microsoft.com/en-us/library/182ax5k8.aspx
for example, a delete command with the

<br />
ExecuteNonQuery()<br />

CodeHawkz · Answer 2 · 2012-09-04T21:03:00

Solution 1

Hey there,

It would be very easy, isn't it? You said you got a list of connection strings in the config file. So each connection string is given a name, right?

C#

foreach (ConnectionStringSettings connectionString in ConfigurationManager.ConnectionStrings)
{
  Console.WriteLine(connectionString.Name);
}

You can either pull these names from the config and put it in a drop down or you can write a mapping between the connection string names with some other text that you want to display and show that in the drop down. The latter method only makes sense when the connection string names doesn't make sense or something.

Hope this helps, Regards

Posted 4-Sep-12 21:03pm

CodeHawkz

Comments

suhailnoorpawane 5-Sep-12 3:15am

Hey buddy thanks for response.
But the thing is that i have got country dropdown like INDIA,Germany,US and if i select INDIA INDIA specific connectionstring should only load and so on for others. your solution will get only name but wont load that specific connection.
If i am right let me know

Thanks once again

CodeHawkz 5-Sep-12 7:37am

List<string> names = new List<string>();
foreach (ConnectionStringSettings connectionString in ConfigurationManager.ConnectionStrings)
{
names.Add(connectionString.Name);
}
// This for loop gives you the list of names, bind this to the drop down

string countryConnectionString = ConfigurationManager.ConnectionStrings["selected connection string name"].ToString();
// This gets you the connection string based on the selection