How do I change data source name dynamically in ASP.NET web based

Question

1.00/5 (1 vote)

See more:

i am working on web application where i have to change data source dynamically in entity framework .
error i faced is

The network path was not found

What I have tried:

SqlConnection con = null;
            var dbToUse = objser.Getip((ddcmpname.SelectedValue).ToString()).ToList();

            con = new SqlConnection(string.Format("server=.;database={0};", dbToUse));
 
            string yourConnection = ConfigurationManager.ConnectionStrings["Entities"].ConnectionString.Replace("dbname", dbToUse[0].Location);
            con = new SqlConnection(yourConnection);
con.open();

Posted 10-Dec-18 23:46pm

Member 14085179

Updated 11-Dec-18 0:53am

Add a Solution

Comments

F-ES Sitecore 11-Dec-18 6:41am

The connection string you are creating is probably referencing a machine that can't be found. We don't know what your connection string is, and we can't access your network to tell you why that connection string is invalid.

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)

Afzaal Ahmad Zeeshan · Accepted Answer · 2018-12-11T00:53:00

I don't know whether I follow you here or not, but,

// Why this? 
con = new SqlConnection(string.Format("server=.;database={0};", dbToUse));
 
string yourConnection = ConfigurationManager.ConnectionStrings["Entities"].ConnectionString.Replace("dbname", dbToUse[0].Location);

// When you have to do this! 
con = new SqlConnection(yourConnection);

Change your code to this,

SqlConnection con = null;
var dbToUse = objser.Getip((ddcmpname.SelectedValue).ToString()).ToList();
 
string yourConnection = ConfigurationManager.ConnectionStrings["Entities"].ConnectionString.Replace("dbname", dbToUse[0].Location); // Assuming dbToUser[0] has a Location property
con = new SqlConnection(yourConnection);
con.open();

The reason I remove the previous statement was, that it does not make any difference. You are not opening the connection for that object type, you are however making a connection here. With this code, you just need to make sure your path is correct.

If the path is incorrect, we are unable to help because we do not know your networks settings and configurations. In this case, SQL Server connection strings - ConnectionStrings.com[^], would be able to help you out.