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

来源:百度知道 编辑:UC知道 时间:2024/05/19 10:56:08
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?????

using System.Configuration;

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

少了
<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>

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

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

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

加上providerName = "System.Data.SqlClient"