如题:System.InvalidOperationException: ConnectionString 属性尚未初始化。源错误:
行 76:
行 77: //执行命令
行 78: myConnection.Open();
行 79: SqlDataReader reader = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
行 80:
源文件: d:\LXQJ\My Documents\Visual Studio 2005\WebSites\WebSite1\App_Code\UsersDB.cs 行: 78 部分代码:
//创建一个数据库连接实例和命令对象
SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["connectionstring"]);
SqlCommand myCommand = new SqlCommand("AddUser", myConnection);web。config里的配置代码:
<configuration>
<appSettings/>
<connectionStrings>
<add name="ConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Students.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/>
</connectionStrings>
<system.web>
在线等,谢谢!~
行 76:
行 77: //执行命令
行 78: myConnection.Open();
行 79: SqlDataReader reader = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
行 80:
源文件: d:\LXQJ\My Documents\Visual Studio 2005\WebSites\WebSite1\App_Code\UsersDB.cs 行: 78 部分代码:
//创建一个数据库连接实例和命令对象
SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["connectionstring"]);
SqlCommand myCommand = new SqlCommand("AddUser", myConnection);web。config里的配置代码:
<configuration>
<appSettings/>
<connectionStrings>
<add name="ConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Students.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/>
</connectionStrings>
<system.web>
在线等,谢谢!~
你的代码中:ConfigurationSettings.AppSettings["connectionstring"]
appSettings节你都没设,在代码中又何来的AppSettings[xxx]呢....你应该是用datasource组件新建连接自动生成的连接字符串吧,如果是的话,你可以:
SqlConnection myConnection = new SqlConnection(datasource.ConnectionString);又或者在appSettings节中增加连接字符串
<appSettings><add key="connString" value="连接字符串"></appSettings>
然后就可以在代码中调用了:
ConfigurationSettings.AppSettings["connString"]——luckyboy 20091123