web.config database connection error

zenlee

<configuration>
   <appSettings>
        <add key="msn" value="server=127.0.0.1;uid=sa;pwd=sa;database=BookShop" />
   </appSettings>
</configuration>

string strConString = ConfigurationSettings.AppSettings[ "msn" ];

Maybe this line, you try it!

牛头背包客

<appSettings>
    <add key="connstr" value="server=.;uid=zbr;pwd=#szzemucompany#;database=dbok" />
</appSettings>

--------------------
public static string ConnStr=System.Configuration.ConfigurationSettings.AppSettings["ConnStr"];


If it doesn't work again, it's not a problem in this regard.

zjjhjjordan

using System.Configuration;
public static int ExecuteSql(string strSql)
        {
SqlConnection myconn = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["ConnStr"]);
SqlCommand mycomm = new SqlCommand(strSql, myconn);


Try

zephyr1982

It turned out that\in the instance name of SQLSERVER, ZEMU-A12\COMPANY, was escaped, and I changed it in web.config


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


It is correct to replace $ with\\when reading, thank you brothers upstairs!