aspnetpage为什么不能分页

[leaf_2008]

开发工具vs2003


代码如下
<webdiyer:aspnetpager id="Aspnetpager1" runat="server" PageSize="20" ShowBoxThreshold="1" CustomInfoSectionWidth="20%"
ShowCustomInfoSection="Left" HorizontalAlign="Center" SubmitButtonText="GO" TextBeforeInputBox="转到" TextAfterInputBox="页"> </webdiyer:aspnetpager>


cs文件中的代码如下

private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
BindData("","OrderId desc",1,Aspnetpager1.PageSize);//
AddCustomText();
}
private void Aspnetpager1_PageChanged(object src, Wuqi.Webdiyer.PageChangedEventArgs e)
{
if( Aspnetpager1.CurrentPageIndex != e.NewPageIndex)
{
Aspnetpager1.CurrentPageIndex= e.NewPageIndex;
this.BindData(ViewState["whereClause"].ToString(),"OrderId desc",Aspnetpager1.CurrentPageIndex,Aspnetpager1.PageSize);
AddCustomText();
}
}

public void AddCustomText()
{
//动态设置用户自定义文本内容
Aspnetpager1.CustomInfoText="订单总数： <font color=\"blue\"> <b>"+Aspnetpager1.RecordCount.ToString()+" </b> </font>";
Aspnetpager1.CustomInfoText+=" 总页数： <font color=\"blue\"> <b>"+Aspnetpager1.PageCount.ToString()+" </b> </font> ";
}

private void BindData(string whereClause,string orderBy,int start,int pageLength)
{
int count;
OrdersCollection orders =DataRepository.OrdersProvider.GetPaged(whereClause,orderBy,start-1,pageLength, out count);
ViewState["whereClause"]=whereClause;

if(orders!=null)
{
ViewState["source"]=orders;
}
Aspnetpager1.RecordCount=count;
//datagrid数据绑定
dgOrders.DataSource=ViewState["source"];
dgOrders.DataKeyField="OrderId";
dgOrders.DataBind();
}


大家看哈我这个为什么不能分页啊

[sunzhong2003]

去webdiyer.com去作者的主页下个DEMO看看吧

[leaf_2008]

他的主页现在打不开了

[jiao545214147]

我们都用得蛮好的阿


自己找找原因，搞不好 哪个地方错了




1

1
1
1
1
1
手机代工网，最新的供应信息，采购信息，手机行业资讯。。

[蝶恋花雨]

 string aa ="select c.*,a.uid,a.username,a.itemno,a.browseviews,b.avatar,b.chengni,b.sex,b.jifen,b.dengji,b.bobi,b.qianming,d.club_name,d.club_id";
                aa+=" from bbs_users a inner join  bbs_userfields b on a.uid=b.uid inner join  e8e_Club_ActivityComment c on a.uid=c.commentator";
                aa +=" inner join e8e_Club_Sys d on c.commentator=d.club_userid where c.huodongid='" + Request["huodongid"] + "' order by c.createtime desc ";
                string photonum = "select count(commentid)as num from e8e_Club_ActivityComment  where huodongid=" + Request["huodongid"];
                SQLcon sl = new SQLcon();
                SqlDataAdapter sda;
                DataSet ds = new DataSet();
                SqlCommand sqlcmd;
                sda = new SqlDataAdapter(aa, sl.Connection);
                sda.Fill(ds, AspNetPager1.PageSize * (AspNetPager1.CurrentPageIndex - 1), AspNetPager1.PageSize, "e8e_Club_ActivityComment");
                sqlcmd = new SqlCommand(photonum, sl.Connection);
                sl.ConOpen();
                AspNetPager1.RecordCount = (int)sqlcmd.ExecuteScalar();
                if (ds.Tables.Count > 0)
                {
                    rpComments.DataSource = ds.Tables["e8e_Club_ActivityComment"]; rpComments.DataBind();
                }
                else { spError.InnerHtml = "<font <font style='font-size:xx-large;color:Red' >暂无心语评论</font>"; }
                sl.ConClose();

[takako_mu]

//GridView绑定
    public void GridViewBind()
    {
        DataSet ds = new DataSet();
        RawDataReviewMasterBLL myRawDate = new RawDataReviewMasterBLL();
        ds = myRawDate.GetDateTableForRawData(Plant, Material, Amount, Pstg_DataFrom, Pstg_DataTo, AspNetPager1.PageSize, AspNetPager1.CurrentPageIndex);
        AspNetPager1.RecordCount = myRawDate.GetRecordCountForAspNetPager(Plant, Material, Amount, Pstg_DataFrom, Pstg_DataTo);
        CPSGridView1.DataSource = ds.Tables[0];
        CPSGridView1.DataBind();
        ds.Clear();
    }

    //分页
    protected void AspNetPager1_PageChanged(object sender, EventArgs e)
    {
        GridViewBind();
    }

[Roc_Lee]

this.AspNetPager1.PageSize=pagesize;		
this.AspNetPager1.PageButtonCount=4;
this.AspNetPager1.RecordCount=allcount;

这几个都得定义了