ConfigurationManager.appSettings error

prasanna shah

10y11.6kLearn iOS Programming

namespace

using System;

using System.Collections.Generic;

using System.Configuration;

using System.Data;

using System.Data.SqlClient;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Web;

app1.config

BllStudent.cs

public class BllStudent

{

static string connectionStr = ConfigurationManager.appSettings["myconnection"];

public DataTable getStudents()

{

SqlConnection con = new SqlConnection(connectionStr);

string sql = "select * from tbl_student";

SqlCommand cmd = new SqlCommand(sql, con);

SqlDataAdapter da = new SqlDataAdapter(cmd);

DataSet ds = new DataSet();

da.Fill(ds, "stu");

return ds.Tables["stu"];

}

public static string ConfigurationManager { get; set; }

public string System { get; set; }}

}

error: 'string' does not contain a definition for 'appSettings' and no extension method

'appSettings' accepting a first argument of type 'string' could be found (are you missing

a using directive or an assembly reference)

Hi, this is my problem. Any if got any solution for this please help.

Thank you

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vinay Singh10y ago
Hi
As i suggested in my solution the string is not static. So in you code dot put static wit your string valiable.
So here is the problem
static string connectionStr = ConfigurationManager.appSettings["myconnection"];
just remove the static word from your code . so after removing the static your code will be
string connectionStr = ConfigurationManager.appSettings["myconnection"];
Karthik Elumalai10y ago
Hi prasanna shah,
Below is the one of the way , you can solve your problem .

First place connectionstring in webconfig file like below:

And Access Anywhere like the below:
string con = ConfigurationManager.ConnectionStrings["WebConfig_Con"].ConnectionString;
Hope the above code will solve your problem,kindly let me know your feeback.
Thanks
karthik
prasanna shah10y ago
hi Vinay Singh, thanks for your reply.

I tried as you said. I did
string connectionStr = System.Configuration.ConfigurationManager.AppSettings
["myconnection"].ToString();
but the red error underline was under System and the error was
error:A field initializer cannot reference the non-static field, method or property
'BusinessLayer.BllStudent.System.get'

and after that I did
static string connectionStr = System.Configuration.ConfigurationManager.AppSettings
["myconnection"].ToString();

error: An object reference is required for the non-static field, method or property
'BusinessLayer.BllStudent.System.get'
Vinay Singh10y ago
Hi,
Problem with your way of accessing connection string. have a look
stringval=System.Configuration.ConfigurationManager.AppSettings["myconnectionstring"].ToString();
for detail visit the link
Retrieve Connection String From Web.config In ASP.net Using C#.Net (AppSettings,ConnectionStrings)
In your code check the helighted part. it must be same as above
string connectionStr = ConfigurationManager.appSettings["myconnection"];