datalist数字分页代码

最新推荐文章于 2024-10-10 10:18:46 发布

bmbz5201984

最新推荐文章于 2024-10-10 10:18:46 发布

阅读量220

点赞数 1

文章标签： dataset null sql string

本文链接：https://blog.csdn.net/bmbz5201984/article/details/3960470

版权

public void PageNum()
    {
        string sql = "select *from Calls";
        DataSet ds = DBO.ExecuteDataSet(CommandType.Text, sql, null);
        for (i = 0; i < ds.Tables[0].Rows.Count / 5; i++)
        {
            divPageNum.InnerHtml += "<a href='Default4.aspx?p=" + (i + 1).ToString() + "'>" + (i + 1).ToString() + "</a> ";
        }

        PagedDataSource objPds = new PagedDataSource();
        objPds.DataSource = ds.Tables[0].DefaultView;
        objPds.AllowPaging = true;
        objPds.PageSize = 5;
        if (Request.QueryString["p"] != null)
            CurrentPage = Convert.ToInt32(Request.QueryString["p"]);
        else
            CurrentPage = 1;

objPds.CurrentPageIndex = CurrentPage - 1;

        this.DataList1.DataSource = objPds;
        DataList1.DataBind();
    }