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?????
<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"