打印本文 打印本文 关闭窗口 关闭窗口
asp.net C#查询SQL数据并分页的可参考代码
作者:武汉SEO闵涛  文章来源:敏韬网  点击数1178  更新时间:2009/6/9 2:33:45  文章录入:mintao  责任编辑:mintao

   protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            bind();
        }

    }
    private void bind()
    {
        //用SQL的 like
        string sql = "select * from w_bloglog where uid=" + Session["UID"] + " and logclass like '%" + this.DropDownList1.SelectedValue.ToString() + "%' order by LogTime desc";
        Db g = new Db();//这里是调用我自定义的一个类 你老实写 Gridview绑定就是了
        this.GridView1.DataSource = g.GetGrid(sql);
        this.GridView1.DataKeyNames=new string[]{"logid"};
        this.GridView1.DataBind();
        if (this.GridView1.Rows.Count == 0)
        {
            Response.Write("<div align='center'>没有日志记录</center>");
            this.t.Visible = false;
        }

        CurrPage.Text = "第" + Convert.ToInt32(GridView1.PageIndex + 1).ToString() + "页,共" + GridView1.PageCount + "页";
        int curpage = Convert.ToInt32(GridView1.PageIndex + 1);
        this.MoveFirst.Enabled = true;
        this.MoveLast.Enabled = true;
        this.MoveNext.Enabled = true;
        this.MovePrev.Enabled = true;
        if (curpage == 1)
        {
            this.MoveFirst.Enabled = false;//不显示第一页按钮
            this.MovePrev.Enabled = false;//不显示上一页按钮
        }
        if (curpage == GridView1.PageCount)
        {
            this.MoveNext.Enabled = false;//不显示下一页
            this.MoveLast.Enabled = false;//不显示最后一页
        }
 
    }
    //自定义分页
    protected void PagerChange(object sender, CommandEventArgs e)
    {

        switch (Convert.ToString(e.CommandArgument))
        {
            case "next":
                //  bind();
                if (GridView1.PageIndex < GridView1.PageCount - 1)
                    GridView1.PageIndex = GridView1.PageIndex + 1;

                bind();
                break;
            case "prev":
                //  bind();
                if (GridView1.PageIndex > 0)
                    GridView1.PageIndex = GridView1.PageIndex - 1;

                bind();
                break;
            case "last":
                GridView1.PageIndex = GridView1.PageCount - 1;
                bind();
                break;
            case "fir":
                GridView1.PageIndex = 0;
                bind();
                break;
        }
    }
    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        GridView1.EditIndex = -1;
        this.GridView1.PageIndex = e.NewPageIndex;//分页绑定

        bind();
    }

打印本文 打印本文 关闭窗口 关闭窗口