The ConnectionString property has not been initialized

[kingsep11]

hi
I am doing project under entire architecture in ASP.Net ,, But i am getting coonection error while running the program

connection at webconfig is below:

  <appSettings>
 
    <add key="Myconn" value="server=.;uid=;pwd=;Initial Catalog=tempdb;Integrated Security=true"/>
      </appSettings >
 

my code on calling connection is

using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
 
/// <summary>
/// Summary description for clsvarDeclaration
/// </summary>
public class clsvarDeclaration
{
    private static SqlConnection con = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["Myconn"]);
 
 
    public clsvarDeclaration()
    {
        //
        // TODO: Add constructor logic here
        //
    }
 
    public static SqlConnection connection
    {
        get
        {
            return con;
        }
        set
        {
            con = value;
        }
    }
}
 

but it shows error: The ConnectionString property has not been initialized


Any suggetions most Welcome

[Plater]

Well, I am not sure why that doesnt work, but I have used this with success:

private static AppSettingsReader ap = new AppSettingsReader();
 
public static string ConnectionString
{
   get
   {
      return ap.GetValue("mycon", typeof(string)).ToString();
   }
}
 

ALSO: On the connection string you have (I assume you removed those values for safety reasons), using Integrated Security=true negates the uid and pwd statements, which are not even valid statements for SqlConnection:
http://www.connectionstrings.com/?carrier=sqlserver