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"的局部变量
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"的局部变量
解决方案 »
- 转ORACLE语句
- Linq to sql 怎么绑定属性的属性?Eval("User.Username")报错
- Asp.net换行问题
- 如何实现自动连接百度,然后进行搜索?
- 充值功能代码
- GridView导出EXCEL后,GV里面的内容和EXCEL不一致
- 在使用gridview时能不能变换显示的内容
- 代码显示不了???
- 这两个连接字符串区别在哪?为什么效果不同?
- 写给水晶报表的高手 acptvb(微软全球技术中心 VB技术支持)上回问题搞定,这回还有一个很急的问题。请一定帮忙!!
- ASP.NET数据表格导入导出问题和TextBox问题
- 手动代码 添加deletecommend rowdeleting 索引超出范围
<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> 中红色部分改成添加到
<appSettings>
<add name="MyConnectionString" connectionString="Data Source=localhost;Initial Catalog=dbname;user id=admin;password=admin"/>
</appSettings>
<connectionStrings/>
System.Configuration.ConfigurationSettings.AppSettings[]你这里用的AppSettings,在web.config文件里面就用<appSettings>这个节点.
ConfigurationManager.ConnectionStrings[]这里用ConnectionStrings,在web.config文件里面就用<connectionStrings>节点
是System.Web.Configuration命名空间下的。
换成如下:
string connectionString = System.Configuration.ConfigurationManager.AppSettings["MyConnectionString"];