I gave the above string,I want to get the serveripaddress,DB1,uid and **** these values from that string.
-
At least show us what you already got. This question otherwise looks like "Hey, SO, solve my task for me"Joey– Joey2009-10-27 09:34:06 +00:00Commented Oct 27, 2009 at 9:34
Add a comment
|
4 Answers
Don't use a regex.
Parse the connection string using SqlConnectionStringBuilder and then access the keys from that.
var b = new SqlConnectionStringBuilder(myConnectionString);
var dataSource = b["Data Source"];
// etc.
Much easier, more maintainable and more reliable.
Comments
data source=([^;]*);Initial Catalog=([^;]*);user id=([^;]*);Password=([^;"]*)
You then have the matches in groups 1 to 4. If you get bored you can name the groups; helps readability of the code, though rarely helps readability of the regex itself.
1 Comment
Peter
+1 since subramani only says thank you, and never heard of accepting or voting up apparently
There is no need to parse a connection string when the BCL can do it for you:
var builder = new OleDbConnectionStringBuilder(connectionString);
var provider = builder.Provider;
var dataSource = builder.DataSource;
var initialCatalog = builder["Initial Catalog"];
var userID = builder["User ID"];
var password = builder["Password"];
Note that for an OLE DB connection string, only the standard cross-provider properties have strongly-typed property names, all the rest are accessed via the indexer.
Comments
Isn't it easier to split value using ';' char and then split every item by '=' char?
This way your connection string could be edited by users and even item order could be changed.
