Getting specific values from connection string

Question

I have string like below;

oradb = Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.87.50)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=testdb)));User Id = john; Password=test;

I want to get only '192.168.87.50' , '1521' , 'testdb' , 'john' from above connection string and put into some textboxes.

I tried to make with regexp and understand that it's not possible with regexp.

How can I do it?

You could read the ConnectionString in using ConfigurationManager and then load up a System.Configuration.ConnectionStringSettings class and retrieve what you want using Properties from there? — user3180309
– user3180309, Commented Nov 29, 2017 at 17:30
@jmb.mage this is winform btw. Also how can i get the specified parameters one by one. Can you please write this as an answer ? — john true
– john true, Commented Nov 29, 2017 at 17:39

Aleks Andreev · Accepted Answer · 2017-11-29 17:43:34Z

2

While there should be a more convenient way, you still can use RegExp for this.
Try this code:

var input =
    "Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.87.50)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=testdb)));User Id = john; Password=test;";


var hostRegx = new Regex("HOST\\s*=\\s*(?<host>[^\\)]+)");
var portRegx = new Regex("PORT\\s*=\\s*(?<port>[^\\)]+)");
var dbRegx = new Regex("SERVICE_NAME\\s*=\\s*(?<db>[^\\)]+)");
var userRegx = new Regex("User Id\\s*=\\s*(?<user>[^;]+)");
var passRegx = new Regex("Password\\s*=\\s*(?<pass>[^;]+)");

var host = hostRegx.Match(input).Groups["host"].Value;
var port = portRegx.Match(input).Groups["port"].Value;
var db = dbRegx.Match(input).Groups["db"].Value;
var user = userRegx.Match(input).Groups["user"].Value;
var pass = passRegx.Match(input).Groups["pass"].Value;

answered Nov 29, 2017 at 17:43

Aleks Andreev

7,0548 gold badges31 silver badges38 bronze badges

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

2 Comments

john true Over a year ago

Worked like a charm.

Aleks Andreev Over a year ago

@johntrue thank you. By the way, I'm think my approach can be optimized, maybe with one huge regex

Pang · Accepted Answer · 2017-12-05 01:00:28Z

1

You can use connection object to retrieve all these information.

SqlConnection connection = new SqlConnection(connectionString); var dbName = connection.Database;

For server name:

DbConnection connection = new SqlConnection(connectionString); 
var server = connection.DataSource;

edited Dec 5, 2017 at 1:00

Pang

10.2k146 gold badges87 silver badges126 bronze badges

answered Nov 29, 2017 at 18:58

Harish

3374 silver badges14 bronze badges

Collectives™ on Stack Overflow

Getting specific values from connection string

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related