How To :App.Config

  • Thread starter Thread starter Sincere
  • Start date Start date
S

Sincere

Hello,

I am having probelms reading the app.config file. I have stored my
connectionstring as follows.

<add name ="ReqCon" connectionString =
"Data Source= {local};Initial Catalog=Tasks_Sch;
Integrated Security=SSPI" providerName ="System.Data.SqlClient"/>
</connectionStrings>


Following is the code in the data layer class:

Imports System
Imports Microsoft.ApplicationBlocks.Data
Imports System.Data
Imports System.Data.SqlClient
Imports System.Configuration.ConfigurationManager
Imports System.Configuration


Dim strConnect As String =
System.Configuration.ConfigurationManager.AppSettings("ReqCon")
cn.ConnectionString = (strConnect)
cn.Open()

Database server am using is SQL 2005


TIA

Regards
 
Because the Net method gives often for some people problems, there is in VB
the much easier namespace My which contains the shared class

My.Settings

Have a look at that

Cor
 
Sincere said:
Hello,

I am having probelms reading the app.config file. I have stored my
connectionstring as follows.

<add name ="ReqCon" connectionString =
"Data Source= {local};Initial Catalog=Tasks_Sch;
Integrated Security=SSPI" providerName ="System.Data.SqlClient"/>
</connectionStrings>


Following is the code in the data layer class:

Imports System
Imports Microsoft.ApplicationBlocks.Data
Imports System.Data
Imports System.Data.SqlClient
Imports System.Configuration.ConfigurationManager
Imports System.Configuration


Dim strConnect As String =
System.Configuration.ConfigurationManager.AppSettings("ReqCon")
cn.ConnectionString = (strConnect)
cn.Open()

Database server am using is SQL 2005


TIA

Regards
Click to expand...

Shouldn't you be using ConfigurationManager.ConnectionStrings, rather than
ConfigurationManager.AppSettings?

Mike
 
so the namespace name is My.Settings ?

Cor Ligthert said:
Because the Net method gives often for some people problems, there is in VB
the much easier namespace My which contains the shared class

My.Settings

Have a look at that

Cor
Click to expand...
 
Back
Top