Not able to get connection string from Web.config file in asp.net 4.5

asp.netasp.net-mvc-4connection-stringweb.config

Currently I'm trying to connect SQL server DB from asp.net 4.5, keeping the connection string on Web.config file, using the following code to retrieve the connection string, but its retunr NULL value,

ConnectionStringSettings connString = ConfigurationManager.ConnectionStrings["ConString"];                 
SqlConnection Con = new SqlConnection(connString.ConnectionString);

the connection string in Web.Config is like

<connectionStrings>
  <add name="ConString" 
    connectionString="Data Source=myservername;Initial Catalog=dbname;User ID=userid;Password=password;Integrated Security=True" 
    xdt:Transform="SetAttributes" xdt:Locator="Match(name)"/>
</connectionStrings>

I'm not understanding why it return null value, previously, in 3.5 I have used the following code to get the connection string,

Con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["ConString"].ConnectionString);

it was working fine asp.net 3.5, but this also getting runtime error while using. Please let me know if I did any mistake.

Best Answer

Although, this is a mere suggestion/things to check, I am adding this as an answer

1) Can you please check if the web.config is at its right location?
2) Also, do you have any web.config (which overrides main web.config) in the same folder as that of your page?

Related Solutions

Escape quote in web.config connection string

Use " instead of " to escape it.

web.config is an XML file so you should use XML escaping.

connectionString="Server=dbsrv;User ID=myDbUser;Password=somepass&quot;word"

See this forum thread.

Update:

" should work, but as it doesn't, have you tried some of the other string escape sequences for .NET? \" and ""?

Update 2:

Try single quotes for the connectionString:

connectionString='Server=dbsrv;User ID=myDbUser;Password=somepass"word'

Or:

connectionString='Server=dbsrv;User ID=myDbUser;Password=somepass&quot;word'

Update 3:

From MSDN (SqlConnection.ConnectionString Property):

To include values that contain a semicolon, single-quote character, or double-quote character, the value must be enclosed in double quotation marks. If the value contains both a semicolon and a double-quote character, the value can be enclosed in single quotation marks.

So:

connectionString="Server=dbsrv;User ID=myDbUser;Password='somepass&quot;word'"

The issue is not with web.config, but the format of the connection string. In a connection string, if you have a " in a value (of the key-value pair), you need to enclose the value in '. So, while Password=somepass"word does not work, Password='somepass"word' does.

C# – Read connection string from web.config

You need to add a reference to System.Configuration and then use:

System.Configuration.ConfigurationManager.
    ConnectionStrings["connectionStringName"].ConnectionString;

Best Answer

Related Solutions

Escape quote in web.config connection string

C# – Read connection string from web.config

Related Topic