How do I parse name/value pairs from a config string?

[Bill]

If, for example, I retrieve a connectionstrin g from a config file using
something like:

Value = ConfigurationSe ttings.AppSetti ngs["ConnectionStri ng"];

This will return a string that is semi-colon delimited. If I want, say, to
retrieve the password from this string will I need to explicity parse it?

[Jay B. Harlow [MVP - Outlook]]

Bill,
I normally use String.Split to separate each pair, then use String.Split
again to separate the pairs.

Optionally putting the name/value pairs into a HashTable or
NameValueCollec tion.

Instead of the second String.Split I've used String.IndexOf &
String.SubStrin g to split the pairs, as there should be only a single split
needed...

Hope this helps
Jay

"Bill" <nf*@nospam.com > wrote in message
news:Ot******** *****@TK2MSFTNG P12.phx.gbl...

If, for example, I retrieve a connectionstrin g from a config file using
something like:

Value = ConfigurationSe ttings.AppSetti ngs["ConnectionStri ng"];

This will return a string that is semi-colon delimited. If I want, say, to
retrieve the password from this string will I need to explicity parse it?

[Shiva]

Yep. You may use String.Split() to get individual ';' separated items and
another String.Split() (or String.StartsWi th() ) on the first set to get the
password.

HTH.

"Bill" <nf*@nospam.com > wrote in message
news:Ot******** *****@TK2MSFTNG P12.phx.gbl...
If, for example, I retrieve a connectionstrin g from a config file using
something like:

Value = ConfigurationSe ttings.AppSetti ngs["ConnectionStri ng"];

This will return a string that is semi-colon delimited. If I want, say, to
retrieve the password from this string will I need to explicity parse it?

[alaspin]

If you wanted to get really excited you could use Regular Expressions:

In VB.NET (I doubt the C# is a million miles away) :

'don't forget to import the namspace
Imports System.Text.Reg ularExpressions

'later...
'we're assuming a SQL Server connection string here and SQL Server
'Authentication
Dim regExp as new Regex("server=\ w*;")
Dim m Match

m = regExp.Match(st rDBConnectionSt ring, "pwd=\w*;")

If m.Success Then
'you've found it...
End If

Notice the "\w*" bit is searching for a "word" in the phrase searched.

This would work with the other bits of the connection string too by tweaking
the expression BUT I have found the "word" gets confused if your server is
being identified by an IP address instead of it's name...

Probably all those "."'s :)

al*****@yahoo.c om

"Bill" wrote:

If, for example, I retrieve a connectionstrin g from a config file using
something like:

Value = ConfigurationSe ttings.AppSetti ngs["ConnectionStri ng"];

This will return a string that is semi-colon delimited. If I want, say, to
retrieve the password from this string will I need to explicity parse it?

[Bill]

Thanks... Reqular Expressions strikes me as the way to go.

"alaspin" <al*****@discus sions.microsoft .com> wrote in message
news:48******** *************** ***********@mic rosoft.com...

If you wanted to get really excited you could use Regular Expressions:

In VB.NET (I doubt the C# is a million miles away) :

'don't forget to import the namspace
Imports System.Text.Reg ularExpressions

'later...
'we're assuming a SQL Server connection string here and SQL Server
'Authentication
Dim regExp as new Regex("server=\ w*;")
Dim m Match

m = regExp.Match(st rDBConnectionSt ring, "pwd=\w*;")

If m.Success Then
'you've found it...
End If

Notice the "\w*" bit is searching for a "word" in the phrase searched.

This would work with the other bits of the connection string too by tweaking the expression BUT I have found the "word" gets confused if your server is
being identified by an IP address instead of it's name...

Probably all those "."'s :)

al*****@yahoo.c om

"Bill" wrote:

If, for example, I retrieve a connectionstrin g from a config file using
something like:

Value = ConfigurationSe ttings.AppSetti ngs["ConnectionStri ng"];

This will return a string that is semi-colon delimited. If I want, say, to retrieve the password from this string will I need to explicity parse it?