Question

ExecuteReader: CommandText 属性尚未初始化

SqlConnection conn = new SqlConnection(DbHelperSQL.strConn);
SqlDataAdapter da = new SqlDataAdapter(str,conn);

DataTable dt = new DataTable();
da.Fill(dt);
PagedDataSource pds = new PagedDataSource();
page.RecordCount = dt.Rows.Count;
pds.AllowPaging = true;
pds.PageSize = page.PageSize;
pds.CurrentPageIndex = page.CurrentPageIndex - 1;
pds.DataSource = dt.DefaultView;
rptGQ.DataSource = pds;
rptGQ.DataBind();

点击第二页就出现这个问题 怎么修改
protected void databind(string str, Wuqi.Webdiyer.AspNetPager page)
｛
// 代码在这里
｝

Answer 1

SqlConnection conn = new SqlConnection(DbHelperSQL.strConn);   
   string sql="select ....";
       SqlCommand cmd=new SqlCommand(sql,conn );
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        conn.open();

        DataTable dt = new DataTable();
        da.Fill(dt);
        conn.close();
        PagedDataSource pds = new PagedDataSource();
        page.RecordCount = dt.Rows.Count;
        pds.AllowPaging = true;
        pds.PageSize = page.PageSize;
        pds.CurrentPageIndex = page.CurrentPageIndex - 1;
        pds.DataSource = dt.DefaultView;
        rptGQ.DataSource = pds;
        rptGQ.DataBind();