web.config database connection error

zephyr1982

Use strConn in SqlConnection myconn = new SqlConnection (strConn);
"Server = ZEMU-A12\COMPANY; UID = zbr; PWD = # szzemucompany #; Database = dbok" instead of running without problems, but if you read <add key = "strConnString" value = "Server = ZEMU-A12\COMPANY ; UID = zbr; PWD = # szzemucompany #; Database = dbok "> </ add> When the value of strConnString is reported, an" instance failed "error is reported, ask the reason
   protected static string strConn = System.Configuration.ConfigurationManager.AppSettings ["strConnString"];
        
        public static int ExecuteSql (string strSql)
        {
            SqlConnection myconn = new SqlConnection (strConn);
            SqlCommand mycomm = new SqlCommand (strSql, myconn);
            try
            {
                myconn.Open ();
                mycomm.ExecuteNonQuery ();
                return 0;
            }
            catch (System.Data.SqlClient.SqlException e)
            {
                throw new Exception (e.Message);
            }
            finally
            {
                mycomm.Dispose ();
                myconn.Close ();
            }
        }

Web.Config file contents:

<? xml version = "1.0" encoding = "utf-8"?>
<configuration>
  <appSettings>
    <add key = "strConnString" value = "Server = ZEMU-A12\COMPANY; UID = zbr; PWD = # szzemucompany #; Database = dbok"> </ add>
    <add key = "WebSiteVersion" value = "Ver1.0"> </ add>
    <add key = "WebManger" value = "Windxf"> </ add>
  </ appSettings>
</ configuration>

fifa112

<add key="strConnString" value="Server=ZEMU-A12\COMPANY;UID=zbr;PWD=#szzemucompany#;Database=dbok"></add>

The following </add> is directly replaced with />Try it out

zephyr1982

No, it's the same error

疾风劲草

protected static string strConn = System.Configuration.ConfigurationManager.AppSettings["strConnString"];
Replace with
protected static string strConn = System.Configuration.ConfigurationSettings.AppSettings["strConnString"];
Try

xfeiniao

Is there a problem with the incoming Japanese SQL statement?

sukdevils

protected static string strConn = System.Configuration.ConfigurationSettings.AppSettings["strConnString"];
Agree with this method but introduce a namespace, check it and you will know

freedust

strConn=ConfigurationSettings.AppSettings("strConnString")

zephyr1982

protected static string strConn = System.Configuration.ConfigurationSettings.AppSettings["strConnString"];


In fact, I used the above method before, the namespace was also introduced, or the error of the reported instance failure, I later changed to

protected static string strConn = System.Configuration.ConfigurationManager.AppSettings["strConnString"];

liuhua56

<configuration>
  <appSettings>
    <add key="conString"
     value="Server=localhost;UID=sa;PWD=secret;Database=Northwind" />
  </appSettings>
</configuration>

-------------------------
string strConString = ConfigurationSettings.AppSettings[ "conString" ];

zephyr1982

Boss, it still doesn't work