CODEWITHSUNDEEP
c#.netasp.net
selvi
selvi

Reputation: 251

Compiler Error Message: CS0118: 'System.Configuration.ConfigurationManager.AppSettings' is a 'property' but is used like a 'method'

Compiler Error Message: CS0118: 'System.Configuration.ConfigurationManager.AppSettings' is a 'property' but is used like a 'method'

<add key="ObjConn" value="Provider=SQLOLEDB;Persist Security Info=True;User ID=OMembers;PWD=OMembers;Initial Catalog=Db;Data Source=""/>

 strconnection = System.Configuration.ConfigurationManager.AppSettings("ObjConn");
          sqlcon = new SqlConnection(strconnection);

Upvotes: 3

Views: 2543

Answers (3)

Icarus
Icarus

Reputation: 63966

Better to define connection strings in the connection strings section as so:

<connectionStrings>
   <add 
      name="ObjConn" 
      connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true" 
      providerName="System.Data.SqlClient"
   />
</connectionStrings>

And instantiate you SqlConnection like this: 

strconnection = System.Configuration.ConfigurationManager.ConnectionStrings["ObjConn"].ConnectionString;
sqlcon = new SqlConnection(strconnection);

Upvotes: 2

Daryl Teo
Daryl Teo

Reputation: 5495

I believe you're working in C#? You need to access it using index operator:

strconnection = System.Configuration.ConfigurationManager.AppSettings["ObjConn"];

Upvotes: 3

Davide Piras
Davide Piras

Reputation: 44605

in C#, do this:

strconnection = System.Configuration.ConfigurationManager.AppSettings["ObjConn"];
sqlcon = new SqlConnection(strconnection);

Upvotes: 7

Related Questions