DataList分页功能代码

公告

Posted on 2010-11-22 14:13 孤∮帆阅读(457) 评论(0) 编辑收藏举报

DataList是不具备自动分页的功能的......

DataList与DataGrid都是很好用的控件，但是非常遗憾的是DataList不具有象DataGrid那样的自动分页功能，即：他不具备PageSize这样的属性来控制分页，而DataGrid却不具备DataList的RepeatDirection和 RepeatColumns属性。发布这个，希望能够帮到刚刚学习.net的朋友

a.aspx页：

a.aspx.cs页：

    private static int PageIndex;//保存当前页的索引
    private static int pagesize;//保存每个页面中的记录数目
    private static int CurrentPage;//为当前页序号-1
    private static int PageCount;//保存总页数
    private static int RecordCount;//总记录数

    public bool DropFill;
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            DropFill = true;
            pagesize = 10;//pagesize = MyDataGrid.RepeatColumns;可以设DataList的属性RepeatDirection="Horizontal" RepeatColumns="10",通过RepeatColumns来设置每页显示的条数
            CurrentPage = 0;
            GetPageCount();//得到总记录数
            Databind();
         }

    }
    public void GetPageCount()
    {
        string sql = "select * from prizes ";
        Conn c1 = new Conn();

SqlCommand cmd = new SqlCommand(sql, c1.SqlConnection());

        SqlDataAdapter da = new SqlDataAdapter(cmd);
        DataSet ds = new DataSet();
        da.Fill(ds, "table");

        RecordCount = ds.Tables["table"].DefaultView.Count;
        c1.SqlConnection().Close();
    }

public void Databind()
    { D1.Items.Clear();
        string sql = "select * from prizes";
        Class1 c1 = new Class1();

SqlCommand cmd = new SqlCommand(sql, c1.SqlConnection());

        SqlDataAdapter da = new SqlDataAdapter(cmd);
        DataSet ds = new DataSet();
        PageIndex = CurrentPage * pagesize;
        da.Fill(ds,PageIndex,pagesize, "table");

        MyDataGrid.DataSource = ds.Tables["table"];
        MyDataGrid.DataBind();
        c1.CloseSqlConnection();

        PageCount = RecordCount / pagesize;
        if (RecordCount % pagesize != 0)
            PageCount++;
        lalPageCount.Text = PageCount.ToString();
        lblRecordCount.Text = RecordCount.ToString();
        if (lblCurrentPage.Text == "")
        {
            lblCurrentPage.Text = "1";
        }

        if (CurrentPage == 0)
        {
            btnFrist.Enabled = false;
            btnPrev.Enabled = false;
        }
        if (CurrentPage == PageCount - 1)
        {
            btnLast.Enabled = false;
            btnNext.Enabled = false;
        }

        //给下拉链表中添加页数
        if (DropFill == true)
        {
            for (int i = 1; i <= PageCount; i++)
            {
                D1.Items.Add(new ListItem(i.ToString()));
            }
        }
        else
        {
            D1.Items.Add("1");
        }

    }
    protected void D1_SelectedIndexChanged(object sender, EventArgs e)
    {
        btnFrist.Enabled = true;
        btnLast.Enabled = true;
        btnNext.Enabled = true;
        btnPrev.Enabled = true;
        DropFill = false;

        CurrentPage = Int32.Parse(D1.SelectedValue.ToString())-1;
        //MyDataGrid.CurrentPageIndex = Pageindex - 1;
        DropFill = false;
        Databind();
        lblCurrentPage.Text = (CurrentPage+1).ToString();

}

    protected void PagerButtonClick(object sender, CommandEventArgs e)
    {
        btnFrist.Enabled = true;
        btnLast.Enabled = true;
        btnNext.Enabled = true;
        btnPrev.Enabled = true;
        DropFill = false;

string age = e.CommandArgument.ToString();

        switch (age)
        {
            case "Next":
                if (CurrentPage < PageCount - 1)
                {
                    CurrentPage++;
                }
                break;
            case "Prev":
                if (CurrentPage > 0)
                {
                    CurrentPage--;
                }
                break;
            case "Frist":
                {
                    CurrentPage = 0;
                }
                break;
            case "Last":
                {
                    CurrentPage = PageCount - 1;
                }
                break;
        }

        //MyDataGrid.CurrentPageIndex = PageIndex;
        Databind();
        lblCurrentPage.Text = Convert.ToString(CurrentPage+1);
    }

刷新页面返回顶部

菜鸟学步

每一天都要进步

公告

DataList分页功能代码