How to parse a connection string

Question

I need to get the server name from my connection string in my web.config file. How can I parse this value out? I have tried split but it wont allow me to split on a = sign. How do I go about parsing this out?

<add name ="Connection" connectionString="server=L\sqlexpress;database=System;User ID=TEst;Password=pass"></add>

I need L\sqlexpress I know it seems simple but I'm not getting it. Thank you for your help.

What do you mean it won't allow you to split on an equal sign character? What is the error message? — mason
– mason, Commented Jan 24, 2014 at 16:26

Steve · Accepted Answer · 2014-01-24 16:25:35Z

5

The class SqlConnectionStringBuilder could be used to initialize an instance with the connectionstring from your web.config. Then you could read the DataSource property

string conString = ConfigurationManager.ConnectionStrings["Connection"].ConnectionString;
SqlConnectionStringBuilder cns = new SqlConnectionStringBuilder(conString);
string dataSource = cns.DataSource;

answered Jan 24, 2014 at 16:25

Steve

217k22 gold badges242 silver badges296 bronze badges

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

Collectives™ on Stack Overflow

How to parse a connection string

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related