Use Second Database in Webiste

Question

0.00/5 (No votes)

See more:

Dear all,

i make a website and now further process i want to apply select query from the another database which i have not connect or not use connection string.

so, i just want to how to Apply select query in another page of my website from the second database.

if it is possible , so please tell me how ?

Thanks and Regards...
Mitesh

Posted 18-Jun-12 22:47pm

Mits Machhi

Add a Solution

Comments

db7uk 19-Jun-12 4:49am

Is the second database on the same server as the first? You can just add another connection string to the app / web.config and use that?????

[no name] 19-Jun-12 4:53am

yes, another database is on same server.so, how can i add in webconfig

5 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)

Om Prakash Pant · Answer 1 · 2012-06-18T23:00:00

In web.config, you can add multiple connection strings as follows:

XML

<connectionStrings>
<add name="connStr1" connectionString="server=localhost;database=yourDb;uid=yourUser;password=password;" />
<add name="connStr2" connectionString="server=localhost;database=yourDb;uid=yourUser;password=password;" />
</connectionStrings>

For reading, use the following code:

C#

string connStr1 = ConfigurationManager.ConnectionStrings["connStr1"].ConnectionString;
string connStr2 = ConfigurationManager.ConnectionStrings["connStr2"].ConnectionString;

Sebastian T Xavier · Answer 2 · 2012-06-18T23:03:00

Solution 2

Just try the following query. Assume your first database is named as Database1 and second one is named as Database2

SQL

Select a.*,b.* from Database1.Table1 as a, Database2.Table1 as b

Hope this helps

Regards
Sebastian

Posted 18-Jun-12 23:03pm

Sebastian T Xavier

Mohamed Mitwalli · Answer 3 · 2012-06-18T23:31:00

Solution 3

Hi ,
You can also use WEB SERVICE
Check this Article
Your first C# Web Service[^]
Best Regards
M.Mitwalli

Posted 18-Jun-12 23:31pm

Mohamed Mitwalli

Raghuveer Kasyap · Answer 4 · 2012-06-18T23:42:00

Hi,

You can use ChangeDatabase() method of the SqlConnection class.

Once the Database is changed you can fire the command.

Another approach is use the <connectionstrings> section of the Web.Config file. Use the ConfigurationManager class to retreive the second connection strong.

Regards,
Raghu

AshishChaudha · Answer 5 · 2012-06-20T00:40:00

Solution 5

Yes it is possible to change database in an application.

please see the following example

SQL

select * from databasename.dbo.tablename

remember, it is for same server.

Posted 20-Jun-12 0:40am

AshishChaudha