Problem with config file

[Ian]

Hi,

Am having trouble retrieving a value from a config file using VC# 2005.

app.config file (as created using 'Settings' tab on Project properties page)
is as follows:

<?xml version="1.0" encoding="utf-8" ?>
<configuratio n>
<configSections >
<sectionGroup name="applicati onSettings"
type="System.Co nfiguration.App licationSetting sGroup, System, Version=2.0.0.0 ,
Culture=neutral , PublicKeyToken= b77a5c561934e08 9" >
<section name="TestSQL.P roperties.Setti ngs"
type="System.Co nfiguration.Cli entSettingsSect ion, System, Version=2.0.0.0 ,
Culture=neutral , PublicKeyToken= b77a5c561934e08 9" requirePermissi on="false" />
</sectionGroup>
</configSections>
<applicationSet tings>
<TestSQL.Proper ties.Settings>
<setting name="SQLDataba se" serializeAs="St ring">
<value>server=( local);uid='sa' ;pwd=''</value>
</setting>
</TestSQL.Propert ies.Settings>
</applicationSett ings>
</configuration>

The code I am using to try to access the SQLDatabase value is:

AppSettingsRead er appReader = new AppSettingsRead er();
string conn = (string)appRead er.GetValue("SQ LDatabase", typeof(string)) ;

When the second line is executed, I get an InvalidOperatio nException saying
that "The key 'SQLDatabase' does not exist in the appSettings configuration
section."

Except it does exist. Cant see anything wrong - no problem with case even -
but I wonder about the namespace in the app.config file that encloses by
value. This corresponds with the default namespace for the project, which is
an ordinary WindowsApplicat ion.

Any idea why I am getting this problem?

Thanks

Ian

[Peter Bromberg [C# MVP]]

Ian,
If you want to put the value in the appSettings section, you can do so easily:

<appSettings>
<add key="SqlDatabas e" value="server=( local);uid='sa' ;pwd='' />
</appSettings>

Read this with: ConfigurationMa nager.AppSettin gs["SqlDataBas e"];

You also have a connectionStrin gs section you can use for this.

Keep it simple if all you need is simple values.
Peter

--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com


"Ian" wrote:

Hi,

Am having trouble retrieving a value from a config file using VC# 2005.

app.config file (as created using 'Settings' tab on Project properties page)
is as follows:

<?xml version="1.0" encoding="utf-8" ?>
<configuratio n>
<configSections >
<sectionGroup name="applicati onSettings"
type="System.Co nfiguration.App licationSetting sGroup, System, Version=2.0.0.0 ,
Culture=neutral , PublicKeyToken= b77a5c561934e08 9" >
<section name="TestSQL.P roperties.Setti ngs"
type="System.Co nfiguration.Cli entSettingsSect ion, System, Version=2.0.0.0 ,
Culture=neutral , PublicKeyToken= b77a5c561934e08 9" requirePermissi on="false" />
</sectionGroup>
</configSections>
<applicationSet tings>
<TestSQL.Proper ties.Settings>
<setting name="SQLDataba se" serializeAs="St ring">
<value>server=( local);uid='sa' ;pwd=''</value>
</setting>
</TestSQL.Propert ies.Settings>
</applicationSett ings>
</configuration>

The code I am using to try to access the SQLDatabase value is:

AppSettingsRead er appReader = new AppSettingsRead er();
string conn = (string)appRead er.GetValue("SQ LDatabase", typeof(string)) ;

When the second line is executed, I get an InvalidOperatio nException saying
that "The key 'SQLDatabase' does not exist in the appSettings configuration
section."

Except it does exist. Cant see anything wrong - no problem with case even -
but I wonder about the namespace in the app.config file that encloses by
value. This corresponds with the default namespace for the project, which is
an ordinary WindowsApplicat ion.

Any idea why I am getting this problem?

Thanks

Ian