我是在按照一本.NET的书上的实例写的代码,用于实现和SQL的相连,请问为什么我调试时,
会出现“当前上下文中不存在mySqlConnection”和“不存在mySqlConnection”的错误呢??代码:
using System;
using System.Data;
using System.Configuration;
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;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
string connectionString = "server=localhost; database=Northwind";
System.Data.SqlClient.SqlConnection.mySqlConnection = new System.Data.SqlClient.SqlConnection(connectionString);
try
{
mySqlConnection.Open();
System.Web.HttpContext.Current.Response.Write("打开数据库成功!");
}
catch (System.Data.SqlClient.SqlException ex)
{
System.Web.HttpContext.Current.Response.Write(ex.Message.ToString());
}
finally
{
mySqlConnection.Close();
System.Web.HttpContext.Current.Response.Write("Close the SQL connection successfully!~");
}
}
}
会出现“当前上下文中不存在mySqlConnection”和“不存在mySqlConnection”的错误呢??代码:
using System;
using System.Data;
using System.Configuration;
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;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
string connectionString = "server=localhost; database=Northwind";
System.Data.SqlClient.SqlConnection.mySqlConnection = new System.Data.SqlClient.SqlConnection(connectionString);
try
{
mySqlConnection.Open();
System.Web.HttpContext.Current.Response.Write("打开数据库成功!");
}
catch (System.Data.SqlClient.SqlException ex)
{
System.Web.HttpContext.Current.Response.Write(ex.Message.ToString());
}
finally
{
mySqlConnection.Close();
System.Web.HttpContext.Current.Response.Write("Close the SQL connection successfully!~");
}
}
}
解决方案 »
- vs2008中无法添加数据连接
- 怎么去掉日期后面的时间啊
- 未将对象引用设置到对象的实例。
- 简单问题 src="~/_js/jsDateYM.js" 和 src="../_js/jsDateYM.js"的区别
- 关于访问DataView时出现"回发或回调参数无效"的问题
- PetShop 在哪看? 我装的vs里有吗?
- vs.net2003如何制作asp.net(c#+access)安装程序
- 请问在asp.net中如何将word或者ppt转换成网页?
- 三天了还没有解决,自定义控件,为何SortCommand事件不触发?
- vs2012中,如何删除自己定制的模板
- [分享]ASP.NET MVC 1 msdn chm version
- RadioButton 的问题
这句话改成System.Data.SqlClient.SqlConnection mySqlConnection = new System.Data.SqlClient.SqlConnection(connectionString);
即去掉mySqlConnection前的点.