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(); }
Copyright @ 2007-2012 敏韬网(敏而好学,文韬武略--MinTao.Net)(学习笔记) Inc All Rights Reserved. 闵涛 E_mail:admin@mintao.net(欢迎提供学习资源)
鄂公网安备 42011102001154号
站长:MinTao ICP备案号:鄂ICP备11006601号-18