asp.net 4 get values from connection string

Question

I have a SQL connection string being stored in the web.config.

How can I pull items like server name, username, password... inside of C# ASP.Net code?

M4N · Accepted Answer · 2010-09-20 23:17:26Z

6

You can use the SqlConnectionStringBuilder for that:

var connectionString = GetConnectionString(); //e.g. use code shown in other answer
var builder = new SqlConnectionStringBuilder(connectionString);

var user = builder.UserID;

There's some sample code on this MSDN page.

edited Sep 20, 2010 at 23:17

answered Sep 20, 2010 at 23:08

M4N

96.8k45 gold badges225 silver badges265 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Doug · Accepted Answer · 2010-09-20 22:49:53Z

1

ConfigurationManager.ConnectionStrings("name of connection string in web.config")

Here is a link to the msdn documentation.

Enjoy!

answered Sep 20, 2010 at 22:49

Doug

5,3581 gold badge26 silver badges31 bronze badges

Comments

PHeiberg · Accepted Answer · 2010-09-20 23:12:52Z

0

Use a Regular Expression or the DbConnectionStringBuilder class in the BCL.

answered Sep 20, 2010 at 23:12

PHeiberg

29.9k6 gold badges61 silver badges82 bronze badges

Collectives™ on Stack Overflow

asp.net 4 get values from connection string

3 Answers 3

Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Linked

Related