Get ConnectionString from app.config in c#

Question

I have defined my connection String in app.config file

<?xml version="1.0" encoding="utf-8" ?>
<configuration>

  <connectionStrings>

    <add name="CString" 
         connectionString="Data Source=Bilal-PC;Initial Catalog=ATMSoftware;Integrated Security=False; User Id=sa; Password=123" 
         providerName="System.Data.SqlClient"/>
  </connectionStrings>
</configuration>

Now I want to get it into my C# class and I have tried all the methods. but I am getting an error on configuration manager.

Please help me.

are you using win forms or web forms? also please detail what error you are getting — naveen, Jan 01 '12 at 14:16
You need to read up on namespaces and the [`using` directive](http://msdn.microsoft.com/en-us/library/sf0df423.aspx). — Oded, Jan 01 '12 at 14:20

score 4 · Answer 1 · answered Jan 01 '12 at 14:19

4

Ensure that you have added a reference to System.Configuration in your project, and place a

using System.Configuration;

statement at the top of your source. The ConfigurationManager type should now be available.

string connectionString = ConfigurationManager.ConnectionStrings["CString"].ConnectionString;

answered Jan 01 '12 at 14:19

devdigital

34,151
9
98
120

By using System.Configuration; it is not available – Snake Jan 01 '12 at 14:20
The question is tagged [homework] - when that happens, we try to give answers that teach, not a complete solution. – Oded Jan 01 '12 at 14:20
I'll leave teaching as the reward for the inquistive mind. – devdigital Jan 01 '12 at 14:23
1

Bilal, have you added the System.Configuration assembly as a reference to your project? In Visual Studio, right click References, Add Reference, .NET, System.Configuration. – devdigital Jan 01 '12 at 14:25

score 1 · Answer 2 · answered Jan 01 '12 at 14:14

1

See MSDN for more information

var conString = ConfigurationManager.ConnectionStrings["LocalSqlServer"];
string strConnString = conString.ConnectionString;

answered Jan 01 '12 at 14:14

Shai

25,159
9
44
67

3

The question is tagged [homework] - when that happens, we try to give answers that _teach_, not a complete solution. – Oded Jan 01 '12 at 14:15
The ConfigurationManager not exist in this context? – Snake Jan 01 '12 at 14:16

Get ConnectionString from app.config in c#

2 Answers2

Linked