ExecuteReader: CommandText 属性尚未初始化

[qq200009]

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;

public partial class ViewProduct : System.Web.UI.Page
{
    public string keytitle, mytitle, keycontent, lbl_Author, lbl_AddTime, lbl_ReadCount,lbldz, lblyb, lbldh, lblEmail;
    protected void Page_Load(object sender, EventArgs e)
    {
        pageload();
        pageload1();
    }
    private void pageload()
    {
        string strqry;
        if (!IsPostBack)
        {
            strqry = "Select * From Product where id =" + Request.QueryString["id"];
            DataRow drw = DBFun.GetDataRow(strqry);
            if (drw == null)
            {
                keycontent = "该作品已删除或不存在！";
                return;
            }
            strqry = "Update Product Set ReadCount=ReadCount+1 where id =" + Request.QueryString["id"];
            DBFun.ExecuteSql(strqry);
            keytitle = drw["ProductName"].ToString();
            lbl_AddTime = drw["AddTime"].ToString();
            lbl_ReadCount = drw["ReadCount"].ToString();
            keycontent = drw["Intro"].ToString();
            mytitle = drw["ProductClass"].ToString();
           // keypicurl = drw["ProductPic"].ToString();

        }
    }
    private void pageload1()
    {

        if (Application["AppSet"] == null)
        {
            DataRow drw = DBFun.GetDataRow("Select * From lxwm");

            Application["SiteUrl"] =                                                                                                                                                                                                     drw["lxwz"].ToString();
            Application["SiteKey"] = drw["lxyx"].ToString();
            Application["SiteDes"] = drw["lsyb"].ToString();
            Application["CopyRight"] = drw["CopyRight"].ToString();
            Application["SiteName"] = drw["lxsj"].ToString();
            Application["SiteDz"] = drw["lsdz"].ToString();
            string[] contact = drw["lxdh"].ToString().Split(',');
            Application["contact"] = contact;
            Application["AppSet"] = "yes";


        }
        if (!IsPostBack)
        {
            if (Application["AppSet"] != null)
            {
                lbldz = Application["SiteDz"].ToString();
                lblEmail = Application["SiteKey"].ToString();
                lblyb = Application["SiteDes"].ToString();
                lbldh = Application["SiteName"].ToString();

            }
        }
    }
}

ExecuteReader: CommandText 属性尚未初始化
说明: 执行当前 Web 请求期间，出现未处理的异常。请检查堆栈跟踪信息，以了解有关该错误以及代码中导致错误的出处的详细信息。

异常详细信息: System.Exception: ExecuteReader: CommandText 属性尚未初始化

[cnartstorm]

这里没有用到啊，DBFun.GetDataRow 这个方法里面的参数你是不是没有传正确呀，如果正确的话肯定是dommandText没有被赋值或被清空了

[xiequan2]

属性尚未初始化检查下SQL语句,表名,列名不匹配问题

[peng_weida]

断点调试 看看

[cailee]

strqry = "Select * From Product where id =" + Request.QueryString["id"];
            DataRow drw = DBFun.GetDataRow(strqry);

跟进入看看，DBFun.GetDataRow(strqry)

[wuyq11]

DBFun.ExecuteSql(strqry);
类里执行语句是什么，跟踪看看。没有配置字符串
或用sqlhelper操作类

[chen_ya_ping]

strqry = "Select * From Product where id =" + Request.QueryString["id"];
上面的代码中你必须要保证Request.QueryString["id"]有值，而且你看id在数据库中肯定是郑兴的吧，那你在上面的代码中要把字符串型转成整型Convert.ToInt32(Request.QueryString["id"])

[gtiroy]

DBFun.ExecuteSql(strqry);
这个用的不对啊

[chen_ya_ping]

不好意思上面的说错了，就看看Request.QueryString["id"]有值没有值，要不你把GetDataRow中的代码贴出来看看

[LYH_OHYES]

strqry = "Select * From Product where id =" + Request.QueryString["id"];
DataRow drw = DBFun.GetDataRow(strqry);
if (drw == null)
{
keycontent = "该作品已删除或不存在！";
return;
}
strqry = "Update Product Set ReadCount=ReadCount+1 where id =" + Request.QueryString["id"];
DBFun.ExecuteSql(strqry);
操作數據庫的時候的sql語句有問題

[gui0605]

DBFun.GetDataRow()这个方法代码贴出来看看

[emoheshang]

你的一些值为空吧,我也老出这样的问题.但一般都是传入的参数为空

[qiuqingpo]

sql代码有问题吧.看一下是不是没有值

[arecaiz]

SQL语名和数据库对比一下

应该是SQL语名的问题

[aspers]

[Quote=引用 10 楼 gui0605 的回复:]
DBFun.GetDataRow()这个方法代码贴出来看看
[/Quote]

public static DataRow GetDataRow(string strSQL)
    {
        if (strSQL.Length==0 )
        { return null;
        }
        //查询数据，取得数据行
        try
        {
            openConnection();
            SqlDataAdapter sqlAdp = new SqlDataAdapter(strSQL, conn);
            DataSet Rs = new DataSet();
            sqlAdp.Fill(Rs);
            if (Rs.Tables[0].Rows.Count != 0)
                return Rs.Tables[0].Rows[0];
            else
                return null;
        }
        catch
        {
            return null;
        }

    }

    public static DataView GetDataView(string strSQL)
    {
        if (strSQL.Length == 0)
        {
            return null;
        }
        //查询数据，取得数据视图
        try
        {
            openConnection();
            SqlDataAdapter OleAdp = new SqlDataAdapter(strSQL, conn);
            DataSet Rs = new DataSet();
            OleAdp.Fill(Rs);
            return Rs.Tables[0].DefaultView;

        }
        catch (Exception e)
        {
            throw new Exception(e.Message);
        }

    }

[程序漫步]

Request.QueryString["id"];
貌似？？

[微工程]

SqlCommand1.Connection = SqlConnection1;
SqlConnection1.Open();
StrQry=“select......”;
SqlCommand1.CommandText = StrQry;
SqlDataReader = SqlCommand1.ExecuteReader();