extract ConnectionString from App.Config

Question

is there any way to extract ConnectionString values from App.Config so server will be put into txtServer, database into txtPassword, UID into txtUser and password into txtPassword?

---

Jassim Rahma

Answer 1

The SqlConnectionStringBuilder class will parse a connection string and provide you with properties corresponding to the key-value pairs in a typical connection string.

http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlconnectionstringbuilder.aspx

Answer 2

Extending Eva's reply, you can apply the things as below,

string connectionString = ConfigurationManager.ConnectionStrings["MyConnString"].ConnectionString;
SqlConnectionStringBuilder sb = new SqlConnectionStringBuilder(connectionString);
string dataSource = sb.DataSource;
string userId = sb.UserID;
string pwd = sb.Password;

---

Please mark this post as answer if it solved your problem. Happy Programming!