how to get the correct code

[Scott Dorman]

Did you also add a "using System.Configurtion" to the file?

Scott. —In just two days, tomorrow will be yesterday. —Hey, hey, hey. Don't be mean. We don't have to be mean because, remember, no matter where you go, there you are. - Buckaroo Banzai

---

[Forum Guidelines] [Articles] [Blog]

[angels777]

yes.. i had added.. the using System.Configuration but still don have the manager thing.

[Laddie]

Looks like you are trying to add this line in the class level where variables are declared. Try using it insie the function / main where you require it.

Thanks Laddie Kindly rate if the answer was helpful

[angels777]

i declare under this.. as global.. i do not want each function declare that.. namespace ttt { public class Dataaccess { private string sqlString = System.Configuration.ConfigurationSettings.AppSettings["connectionString"].ToString(); private SqlConnection cn;

[Scott Dorman]

What does your code look like? Here is a simple example:

using System;
using System.Collections.Generic;
using System.Configuration;
using System.Linq;
using System.Text;

namespace ConsoleApplication1
{
class Program
{
static void Main(string[] args)
{
string test = ConfigurationManager.AppSettings["test"];
}
}
}

Scott. —In just two days, tomorrow will be yesterday. —Hey, hey, hey. Don't be mean. We don't have to be mean because, remember, no matter where you go, there you are. - Buckaroo Banzai

---

[Forum Guidelines] [Articles] [Blog]

[Scott Dorman]

I think you wanted this reply to go to the original poster...

Scott. —In just two days, tomorrow will be yesterday. —Hey, hey, hey. Don't be mean. We don't have to be mean because, remember, no matter where you go, there you are. - Buckaroo Banzai

---

[Forum Guidelines] [Articles] [Blog]

[Scott Dorman]

First, please use the "code block" tags (<pre>) with code blocks like that to preserve the formatting. Second, see my other resposne. You want your code to look something like this:

using System;
using System.Collections.Generic;
using System.Configuration;
using System.Linq;
using System.Text;

namespace DataAccessLayer
{
public class DataAccess
{
private string connectionString;

    public DataAccess()
    {
        this.connectionString = ConfigurationManager.AppSettings\["connectionString"\];

        // you could also use the following, which is the "more correct" way
        // this.connectionString = ConfigurationManager.ConnectionStrings\["connectionString"\];
    }

    public string ConnectionString
    {
        get
        {
            return this.connectionString;
        }
    }
}

}

Scott. —In just two days, tomorrow will be yesterday. —Hey, hey, hey. Don't be mean. We don't have to be mean because, remember, no matter where you go, there you are. - Buckaroo Banzai

---

[Forum Guidelines] [Articles] [Blog]

[Laddie]

Yup..Sorry it is my mistake. You have already replayed it with the code block so it should help the poster now

Thanks Laddie Kindly rate if the answer was helpful

[angels777]

thanks for the wonderful reply... BUT .. i just cant get the $#&(#$ manager Error 3 The name 'ConfigurationManager' does not exist in the current context i had put the below script in the constructor as what u told..also added the using System.Configuration;

this.connectionString = ConfigurationManager.AppSettings["connectionString"];

but just no manager come out..

[Scott Dorman]

It still sounds like you haven't included the reference in the project. This is different than the "using" statement. In Visual Studio, expand the "References" folder of your project and make sure that you see "System.Configuration" listed. That should be all you need to do.

Scott. —In just two days, tomorrow will be yesterday. —Hey, hey, hey. Don't be mean. We don't have to be mean because, remember, no matter where you go, there you are. - Buckaroo Banzai

---

[Forum Guidelines] [Articles] [Blog]