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

Admin | 2009-2-19 11:55:40 | TrackRecord: 2335 Times | Tag标签:asp.net 打印本页

您当前所处的位置是:〖首页〗→【文章页】 本站共有16个图文教程栏目,请用心拜读!

本站提供经典的Excel公式函数实例,Word排版技巧,PPT教程;同时更兼有Flash,PowerPoint,数据库等技术文章。

   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网站防止被采集的中庸之法    下一篇:一组数据计算连号的代码示例

会员评论列表:
针对本篇文章或本站,请您发表个人的建议或批评!
FreeBoxPc

谷歌搜索 百度搜索 本站仅与内容具备一定的实用价值的原创网站交换友情链接,力争为大众做出更优质的服务!
All Rights Reserved版权所有 本站备案信息:滇ICP备11001339号-2 站长联系方式 Email:dzwebs@126.com