“/ShoppingBookGame”应用程序中的服务器错误。
--------------------------------------------------------------------------------ExecuteReader: CommandText 属性尚未初始化
说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。 异常详细信息: System.InvalidOperationException: ExecuteReader: CommandText 属性尚未初始化
public partial class UpImage_Default : System.Web.UI.Page
{
string sqlconn = Convert.ToString(ConfigurationManager.ConnectionStrings["kingconntion"]);
SqlConnection conn;
string sqlcom;
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Request.QueryString["BookName"] != null)
{
sqlcom = "lookup '" + Request.QueryString["BookName"].ToString() + "'";
dlBind();
}
else
{
cz.Text = "没有找到你需要的商品!";
this.lnkbtnOne.Enabled = false;//不显示第一页按钮
this.lnkbtnUp.Enabled = false;//不显示上一页按钮
this.lnkbtnNext.Enabled = false;//不显示下一页
this.lnkbtnBack.Enabled = false;//不显示最后一页
}
}
}
public void dlBind()
{
int curpage = Convert.ToInt32(this.labPage.Text);
PagedDataSource ps = new PagedDataSource();
conn = new SqlConnection(sqlconn);
conn.Open();
SqlDataAdapter MyAdapter = new SqlDataAdapter(sqlcom,conn);
DataSet ds = new DataSet();
MyAdapter.Fill(ds, "Books");
ps.DataSource = ds.Tables["Books"].DefaultView;
ps.AllowPaging = true; //是否可以分页
ps.PageSize = 1; //显示的数量
ps.CurrentPageIndex = curpage - 1; //取得当前页的页码
this.lnkbtnUp.Enabled = true;
this.lnkbtnNext.Enabled = true;
this.lnkbtnBack.Enabled = true;
this.lnkbtnOne.Enabled = true;
if (curpage == 1)
{
this.lnkbtnOne.Enabled = false;//不显示第一页按钮
this.lnkbtnUp.Enabled = false;//不显示上一页按钮
}
if (curpage == ps.PageCount)
{
this.lnkbtnNext.Enabled = false;//不显示下一页
this.lnkbtnBack.Enabled = false;//不显示最后一页
}
this.labBackPage.Text = Convert.ToString(ps.PageCount);
this.DataList1.DataSource = ps;
this.DataList1.DataKeyField = "BookID";
this.DataList1.DataBind();
conn.Close();
if(DataList1.Items.Count==0)
{
cz.Text = "没有找到你需要的商品!";
}
}
protected void LinkButton1_Click1(object sender, EventArgs e)
{
this.labPage.Text = Convert.ToString(Convert.ToInt32(this.labPage.Text) - 1);
this.dlBind(); ;
}
protected void LinkButton2_Click1(object sender, EventArgs e)
{
this.labPage.Text = Convert.ToString(Convert.ToInt32(this.labPage.Text) + 1);
this.dlBind();
}
protected void LinkButton3_Click1(object sender, EventArgs e)
{
this.labPage.Text = "1";
this.dlBind();
}
protected void LinkButton4_Click1(object sender, EventArgs e)
{
this.labPage.Text = this.labBackPage.Text;
this.dlBind();
}
}
--------------------------------------------------------------------------------ExecuteReader: CommandText 属性尚未初始化
说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。 异常详细信息: System.InvalidOperationException: ExecuteReader: CommandText 属性尚未初始化
public partial class UpImage_Default : System.Web.UI.Page
{
string sqlconn = Convert.ToString(ConfigurationManager.ConnectionStrings["kingconntion"]);
SqlConnection conn;
string sqlcom;
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Request.QueryString["BookName"] != null)
{
sqlcom = "lookup '" + Request.QueryString["BookName"].ToString() + "'";
dlBind();
}
else
{
cz.Text = "没有找到你需要的商品!";
this.lnkbtnOne.Enabled = false;//不显示第一页按钮
this.lnkbtnUp.Enabled = false;//不显示上一页按钮
this.lnkbtnNext.Enabled = false;//不显示下一页
this.lnkbtnBack.Enabled = false;//不显示最后一页
}
}
}
public void dlBind()
{
int curpage = Convert.ToInt32(this.labPage.Text);
PagedDataSource ps = new PagedDataSource();
conn = new SqlConnection(sqlconn);
conn.Open();
SqlDataAdapter MyAdapter = new SqlDataAdapter(sqlcom,conn);
DataSet ds = new DataSet();
MyAdapter.Fill(ds, "Books");
ps.DataSource = ds.Tables["Books"].DefaultView;
ps.AllowPaging = true; //是否可以分页
ps.PageSize = 1; //显示的数量
ps.CurrentPageIndex = curpage - 1; //取得当前页的页码
this.lnkbtnUp.Enabled = true;
this.lnkbtnNext.Enabled = true;
this.lnkbtnBack.Enabled = true;
this.lnkbtnOne.Enabled = true;
if (curpage == 1)
{
this.lnkbtnOne.Enabled = false;//不显示第一页按钮
this.lnkbtnUp.Enabled = false;//不显示上一页按钮
}
if (curpage == ps.PageCount)
{
this.lnkbtnNext.Enabled = false;//不显示下一页
this.lnkbtnBack.Enabled = false;//不显示最后一页
}
this.labBackPage.Text = Convert.ToString(ps.PageCount);
this.DataList1.DataSource = ps;
this.DataList1.DataKeyField = "BookID";
this.DataList1.DataBind();
conn.Close();
if(DataList1.Items.Count==0)
{
cz.Text = "没有找到你需要的商品!";
}
}
protected void LinkButton1_Click1(object sender, EventArgs e)
{
this.labPage.Text = Convert.ToString(Convert.ToInt32(this.labPage.Text) - 1);
this.dlBind(); ;
}
protected void LinkButton2_Click1(object sender, EventArgs e)
{
this.labPage.Text = Convert.ToString(Convert.ToInt32(this.labPage.Text) + 1);
this.dlBind();
}
protected void LinkButton3_Click1(object sender, EventArgs e)
{
this.labPage.Text = "1";
this.dlBind();
}
protected void LinkButton4_Click1(object sender, EventArgs e)
{
this.labPage.Text = this.labBackPage.Text;
this.dlBind();
}
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货