access to more than one db of sqlserver

Question

0.00/5 (No votes)

See more:

, +

by only one ConnectionString

Hi

in ConnectionString we can define db by command "Initial Catalog=MyDB;".
I WANTS TO ACCESS TO 2 DB in SQL Server.
is it posible to access to more than one db of sqlserver
by only one ConnectionString?

Thanks Very Much

Posted 22-Dec-14 8:28am

armm1388

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)

Kornfeld Eliyahu Peter · Answer 1 · 2014-12-22T09:28:00

Solution 2

Yes. A single opened connection can access all the databases the current user (the one used to open the connection) has access rights...

C#

SqlConnection oConnection = new SqlConnection(connectionString);
oConnection.Open();
oConnection.ChangeDatabase("mydb1");
// run some query
oConnection.ChangeDatabase("mydb2");
// run some more query
oConnection.Close();

Posted 22-Dec-14 9:28am

Kornfeld Eliyahu Peter

Updated 22-Dec-14 10:35am

v2

Comments

Maciej Los 22-Dec-14 15:31pm

+5!

Kornfeld Eliyahu Peter 22-Dec-14 15:32pm

Thank you...

Maciej Los · Answer 2 · 2014-12-22T09:01:00

Solution 1

Yes, you can use single connection to MS Server to work with more than one database.

To able to achieve that, you need to write query as:

SQL

SELECT <FieldList>
FROM [DatabaseName].[dbo].[TableName]

or

SQL

USE DatabaseName;
SELECT <FieldList>
FROM [TableName]

But, i need to warn you. The best way to fetch data from SQL Server is to use stored procedures.

Posted 22-Dec-14 9:01am

Maciej Los

Comments

Kornfeld Eliyahu Peter 22-Dec-14 15:29pm

You also can use the connection object to set the current database - see my answer...