how to get dbname, servername, user, password, .... from connection string

Question

0.00/5 (No votes)

See more:

Hi,

How to get :
- database
- server
- user
- password
- is integrated security

from connection string
Database=DbName;Server=SomeServer;Integrated Security=SSPI;
or
Database=DbName;Server=SomeServer;User Id=myUsername;Password=myPassword;

Posted 21-Mar-10 23:38pm

tklimczak

Add a Solution

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

dhruvsheth · Answer 1 · 2012-12-22T06:09:00

Solution 6

Quote:
System.Data.Common.DbConnectionStringBuilder builder = new System.Data.Common.DbConnectionStringBuilder();

builder.ConnectionString = ConfigurationManager.ConnectionStrings["inventoryDBConnection"].ConnectionString; ;

string server = builder["Data Source"] as string;
string database = builder["Initial Catalog"] as string;
string UserID = builder["User ID"] as string;
string password = builder["Password"] as string;

This way you can get all the properties.
You may find more help from this MSDN's link:
msdn's link

Hope this will help you.
Thanks.

Posted 22-Dec-12 6:09am

dhruvsheth

Comments

Thomas Daniels 22-Dec-12 12:12pm

This is a question from 2 years ago. Why do you answer to it? The question is solved already.

Jibesh 22-Dec-12 19:29pm

:O thats interesting how the author dig this out where plenty of unanswered question left unattended!!

dhruvsheth 23-Dec-12 8:05am

sorry boss but I was searching for same question and i found this link where i didn't found appropriate ans. so did. so someone will be helped.

VBNetHack 13-Jun-17 12:36pm

Well nearly five years later I found your answer helpful, thanks dhruvsheth :)

dhruvsheth 28-Jun-17 1:38am

Thanks for appreciating.

Dush Abe 20-Feb-20 20:00pm

This answer helped me as well, good job dhruvsheth.

Dush Abe 21-Feb-20 5:15am

This also helped me to do the same in .NET Core 3.1 with following changes
SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder
{
ConnectionString = configuration.GetConnectionString("DefaultConnection")
};

string unProtectedPwd = builder["Password"] as string;

or much better way is:

string server = builder.DataSource;
string database = builder.InitialCatalog;
string UserID = builder.UserID;
string password = builder.Password;

#realJSOP · Answer 2 · 2010-03-21T23:44:00

You have to parse the string. There are a couple of ways to do it, and which way you do it is completely based on your own needs.

0) You can use the string.Split method, splitting on the ';' character, and then parsing the resulting substrings

1) You can use the string.IndexOf() method that walks the string looking for specific items.

Sandeep Mewara · Answer 3 · 2010-03-21T23:51:00

Did you got a chance to look at:
SqlConnection..::.ConnectionString Property[^]

Once you assign the connection string to SqlConnection object, you can access them separately.

For ex:

using (SqlConnection conn = new SqlConnection())
{
    conn.ConnectionString = connectionString;
    // Like this:
    //  conn.DataSource
    //  conn.Database

    //
    //  some work
}

how to get dbname, servername, user, password, .... from connection string

3 solutions

Solution 6

Solution 1

Solution 2

Add your solution here

Preview 0