How to declare ConfigurationManager.ConnectionStrings?

Question

hello i'm using visual studio 2008, vb.net and oracle as my db. this is what i save in my apps.config

<appSettings/>
<add key="SMSDW_connection" value="server=abc;database=efg;User ID=**;Password=**;"/>

and this is my code for calling the apps.config file :

    Dim connectionString = System.Configuration.ConfigurationManager.AppSettings("SMSDW_connection")
    Dim sqlConnection As OracleClient.OracleConnection = New OracleClient.OracleConnection(connectionString)

but still i got an error which is :

The ConnectionString property has not been initialized.

i have add reference System.Configuration and Imports System.Configuration

Why are you using the `appSettings` section when there's a dedicated `connectionStrings` section available? — Damien_The_Unbeliever, Jun 12 '13 at 12:32
i want to call the apps.setting file if i want to make connection for every page. — Husna5207, Jun 13 '13 at 06:40

score 0 · Answer 1 · answered Jun 12 '13 at 11:45

0

The <appSettings> node has the closing tag "/" so the <add is outside of it.

it should read:

<appSettings>
<add ...
</appSettings>

answered Jun 12 '13 at 11:45

Johnfed

106
5

How to declare ConfigurationManager.ConnectionStrings?

1 Answers1