CODEWITHSUNDEEP
c#sql-servervisual-studio-2005
Mohibullah
Mohibullah

Reputation: 571

configurationManager does not exist in the namespace System.Configuration

I have used the following namespace to connect my project to the sql server:

using System.Configuration;

and also used 

string str=System.Configuration.ConfigurationSettings.AppSettings["myconnection"];
SqlConnection oconnection = new SqlConnection(str);
oconnection.Open();

when I run the program ,an error has been occurred and show the message

'System.Configuration.ConfigurationSettings.AppSettings' is obsolete.This method is obsolete,it has been replaced by 'System.Configuration! System.Configuration.ConfigurationManager.AppSettings '

but I have no found ConfigurationManager in that namespace and for oconnection.Open(); the message is

InvalidOperationException

was unhandled.

What can I do?

Upvotes: 57

Views: 79352

Answers (5)

SendETHToThisAddress
SendETHToThisAddress

Reputation: 3704

Install the NuGet package System.Configuration.ConfigurationManager. If you have the using statement using System.Configuration; then you can remove the prefix below

System.Configuration.ConfigurationManager.AppSettings["myconnection"]

and just use

ConfigurationManager.AppSettings["myconnection"]

Upvotes: 0

Pergin Sheni
Pergin Sheni

Reputation: 401

Install System.Configuration from nuget package. Then add reference.

Upvotes: 1

kschieck
kschieck

Reputation: 1447

If you have multiple projects in the solution you have to add the reference System.Configuration to each of them for ConfigurationManager to work in any of them.

Upvotes: 31

Amit K.S
Amit K.S

Reputation: 299

Add a reference of : System.Configuration.dll in your project, then ConfigurationManager will be availiable

Upvotes: 18

Khan
Khan

Reputation: 18142

Go to references, and add a reference to System.Configuration

Once you have done this, you should be able to reference System.Configuration.ConfigurationManager.

string str = System.Configuration.ConfigurationManager.AppSettings["myconnection"];
SqlConnection oconnection = new SqlConnection(str);
oconnection.Open();

From MSDN: The ConfigurationManager class enables you to access machine, application, and user configuration information. This class replaces the ConfigurationSettings class, which is deprecated.

http://msdn.microsoft.com/en-us/library/system.configuration.configurationmanager.aspx

Edit: Addiitonal Information

In reference to the InvalidOperationException. This is caused when the connection string does not specify a data source or server. I am guessing that your connection string is empty.

In your web.config check the location of your connection string. If it falls under the element, then you will need to change your code to search ConnectionStrings and not AppSettings.

string str = System.Configuration.ConfigurationManager.
    ConnectionStrings["myconnection"].ConnectionString;

Upvotes: 85

Related Questions