运行代码时报错
Default.aspx.cs文件
using System;
using System.Data;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Configuration;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void TextBox1_TextChanged(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
string connectionString = System.Configuration.ConfigurationSettings.AppSettings["MyConnectionString"];
SqlConnection con = new SqlConnection(connectionString);
try
{
con.Open();
Label2.Text = " <b>Server Version: </b>" + con.ServerVersion;
Label2.Text = " <br /> <b>Connection Is: </b> " + con.State.ToString();
}
catch (Exception err)
{
Label2.Text = "Error reading the database. " + err.Message;
}
finally
{
con.Close();
Label2.Text +=" <br /> <b>Now Connection Is: </b> " +
con.State.ToString();
}
}
}
Web.config文件
<?xml version="1.0"?>
<configuration>
<appSettings/>
<system.web>
<compilation debug="true"/>
<authentication mode="Windows"/>
</system.web>
<connectionStrings>
<add name="MyConnectionString" connectionString="Data Source=localhost;Initial Catalog=dbname;user id=admin;password=admin"/>
</connectionStrings>
</configuration>
上面 string connectionString = System.Configuration.ConfigurationSettings.AppSettings["MyConnectionString"]; 这一段改成下面这一段的话
string connectionString =
WebConfigurationManager.ConnectionStrings["MyConnectionString "].ConnectionString;
就会提示1.当前上下文中不存在名称"WebConfigurationManager"
但using System.Configuration; 这不是已经引用了命名空间了么? 为什么还提示1.当前上下文中不存在名称"WebConfigurationManager"
还有当我运行上面这些代码的时候提示Error reading the database. ConnectionString 属性尚未初始化。
在 string connectionString = System.Configuration.ConfigurationSettings.AppSettings["MyConnectionString"]; 这个上面填写string connectionString; 的话 显示 已在此范围定义了名为"connectionString"的局部变量