Question

c#web.config中配置连接字符串的问题

web.config中：<appSettings>
<add key="SqlServerConnectStr" value="Server=127.0.0.1;Database=yingcai;User ID=sa;Password=sa"/>
</appSettings>
程序中： SqlConnection con = new SqlConnection
con.ConnectionString = SqlServerConnectStr;
con.Open();
.........
为什么程序中SqlServerConnectStr识别不到，已经加上了using System.Configuration？？？？？

Answer 1

using System.Configuration;

System.Configuration.ConfigurationManager.ConnectionStrings["SqlServerConnectStr"].ToString()

Answer 2

少了
<connectionStrings>
<add name="sts2006dbc" connectionString="Data Source=192.168.0.2;Initial Catalog=ST2006DB;Persist Security Info=True;User ID=sa;Password=123456" providerName="System.Data.SqlClient"/>

</connectionStrings>

Answer 3

SqlConnection con = new SqlConnection();
con.ConnectionString = System.Configuration.ConfigurationManager.AppSettings["SqlServerConnectStr"];

Answer 4

con.ConnectionString = ConfigurationSettings.AppSettings["SqlServerConnectStr"];

Answer 5

using System.Configuration这个DLL也要引用的

Answer 6

加上providerName = "System.Data.SqlClient"