使用using与逐级引用有区别??!定义DataSet那行改成:System.Data.DataSet ds new System.Data.DataSet()
使用using与逐级引用有区别??!
定义DataSet那行改成:System.Data.DataSet ds = new System.Data.DataSet();//改成这样写就没问题了
这是不是说明用using与逐级引用有区别啊??
项目创建是WebSite。 dataset
[解决办法]测试你的代码运行是正常的。
using System;
using System.Data;
using System.Configuration;
using System.Collections;
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 HengCms.DBHelper;
public partial class admin_Test : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
string conStr = SqlHelper.ConnectionString;
using (SqlConnection conn = new SqlConnection(conStr))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = "SELECT * FROM hc_Titles";
DataSet ds = new DataSet();
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
adapter.Fill(ds);//错误在这行
Response.Write(ds.Tables[0].Rows[0][1]);
}
}
}
}
我的测试环境是.net 2.0
[解决办法]更正一下,1#看错了,那个没问题。没看出什么错。
[解决办法] string conStr = ConfigurationManager.ConnectionStrings["conStr"].ConnectionString;
using (SqlConnection conn = new SqlConnection(conStr))
{
using (SqlCommand cmd = conn.CreateCommand("select * from T_Users",conn))
{
DataSet ds = new DataSet();
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
adapter.Fill(ds);
}
}
//没啥问题
[解决办法]改成这样
protected void Button1_Click(object sender, EventArgs e)
{
string conStr = SqlHelper.ConnectionString;
using (SqlConnection conn = new SqlConnection(conStr))
{
SqlCommand cmd = conn.CreateCommand()
cmd.CommandText = "SELECT * FROM hc_Titles";
DataSet ds = new DataSet();
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
adapter.Fill(ds);//错误在这行
Response.Write(ds.Tables[0].Rows[0][1]);
}
}