q; connection string

[Guest]

Hello,

this code does not return connection string
string connStr =
ConfigurationManager.AppSettings["myDBConnectionString"];

app.config
<connectionStrings>
<add name="PVS.Properties.Settings.myDBConnectionString"
connectionString="Data Source=MyServer;Initial Catalog=myDB;User
ID=myUser;Password=myPassword"
providerName="System.Data.SqlClient" />
</connectionStrings>

What is wrong?

 

[Will Asrari]

using System.Data.OleDb;

OleDbConnection cn = new
OleDbConnection(ConfigurationManager.AppSettings["myDBConnectionString"]);

 

[Kevin Spencer]

Your Connection String is not in the AppSettings section of your app.config
file.

--
HTH,

Kevin Spencer
Microsoft MVP
Professional Numbskull

The man who questions opinions is wise.
The man who quarrels with facts is a fool.

 

[MSDN]

<appSettings>

<add name="myDBConnectionString" value="Data Source=MyServer;Initial
Catalog=myDB;User ID=myUser;Password=myPassword" />

</appSettings>

string connStr = ConfigurationManager.AppSettings["myDBConnectionString"];