Dzwebs.Net

撰写电脑技术杂文十余年

asp.net C#查询SQL数据并分页的可参考代码

Admin | 2009-2-19 11:55:40 | 被阅次数 | 9468

温馨提示!

如果未能解决您的问题,请点击搜索;登陆可复制文章,点击登陆

   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();
    }


该杂文来自: 网站开发杂文

上一篇:ASP.NET网站防止被采集的中庸之法

下一篇:一组数据计算连号的代码示例

网站备案号:

网站备案号:滇ICP备11001339号-7

版权属性:

Copyright 2007-2021-forever Inc. all Rights Reserved.

联系方式:

Email:dzwebs@126.com QQ:83539231 访问统计