ant 的个人资料microant照片日志列表更多  |  工具 帮助 |
|
8月25日 gridview存储过程分页（二）在服务器端主要是初始化gridview，也就是第一页。然后就是页码按钮的处理事件，代码如下：  protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { BindGV(this.gvTest, "A101", 5,1, 1, "CID", "CID", null); this.lbtnPrev.Enabled = false; this.lblCurrentInfo.Text = "1"; this.lblCount.Text = getPageNum("A101", 5).ToString() ; } } public int getPageNum(string tableName, int pagesize) { using (SqlDataObject sodo = new SqlDataObject()) { string strSql = "select count(*) from " + tableName; int count =Convert.ToInt32(sodo.ExecuteScalar(strSql)); int pagenum =Convert.ToInt32(Math.Ceiling(Convert.ToDouble(count/pagesize))); return pagenum; } } /// <summary> /// 按钮处理事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> public void PageIndex_Changed(object sender, EventArgs e) { LinkButton linkbtn = (LinkButton)sender; switch (linkbtn.ID.Trim()) { case "lbtnFirst": BindGV(this.gvTest, "A101", 5, 1, 1, "CID", "CID", null); this.lblCurrentInfo.Text = "1"; break; case "lbtnPrev": BindGV(this.gvTest, "A101", 5, Convert.ToInt32(this.lblCurrentInfo.Text) - 1, 1, "CID", "CID", null); this.lblCurrentInfo.Text = (Convert.ToInt32(this.lblCurrentInfo.Text) - 1).ToString(); break; case "lbtnNext": BindGV(this.gvTest, "A101", 5, Convert.ToInt32(this.lblCurrentInfo.Text) + 1, 1, "CID", "CID", null); this.lblCurrentInfo.Text = (Convert.ToInt32(this.lblCurrentInfo.Text) + 1).ToString(); break; case "lbtnLast": BindGV(this.gvTest, "A101", 5, Convert.ToInt32(this.lblCount.Text), 1, "CID", "CID", null); this.lblCurrentInfo.Text = this.lblCount.Text; break; } if (Convert.ToInt32(this.lblCurrentInfo.Text) >= Convert.ToInt32(this.lblCount.Text) && Convert.ToInt32(this.lblCurrentInfo.Text) <=1) { this.lbtnPrev.Enabled = false; this.lbtnNext.Enabled = false; this.lbtnFirst.Enabled = false; this.lbtnLast.Enabled = false; } else if (Convert.ToInt32(this.lblCurrentInfo.Text) >= Convert.ToInt32(this.lblCount.Text)) { this.lbtnPrev.Enabled = true; this.lbtnNext.Enabled = false; this.lbtnFirst.Enabled = true; this.lbtnLast.Enabled = false; } else if (Convert.ToInt32(this.lblCurrentInfo.Text) <= 1) { this.lbtnPrev.Enabled = false; this.lbtnNext.Enabled = true; this.lbtnFirst.Enabled = false; this.lbtnLast.Enabled = true; } else { this.lbtnPrev.Enabled = true; this.lbtnNext.Enabled = true; this.lbtnFirst.Enabled = true; this.lbtnLast.Enabled = true; } } /// <summary> /// 绑定到gridview /// </summary> /// <param name="gv">gridview</param> /// <param name="tableName">分页的表名</param> /// <param name="size">页码大小</param> /// <param name="pageindex">第几页</param> /// <param name="isAsc">升降序</param> /// <param name="OderColumName">排序的列</param> /// <param name="KeyID">主键</param> /// <param name="condictions">查询条件</param> private void BindGV(GridView gv, string tableName, int size, int pageindex, int isAsc, string OderColumName,string KeyID, string condictions) { using (SqlDataObject sodo = new SqlDataObject()) { SqlParameter[] sps = new SqlParameter[7]; sps[0] = new SqlParameter("@TableName", tableName); sps[1] = new SqlParameter("@PageSize", size); sps[2] = new SqlParameter("@PageIndex", pageindex); sps[3] = new SqlParameter("@IsAsc", 1); sps[4] = new SqlParameter("@OderColumName", OderColumName); sps[5] = new SqlParameter("@KeyID", KeyID); sps[6] = new SqlParameter("@Conditions", condictions); DataTable dt = sodo.getDataTable("sp", "sp_CTE", sps); gv.DataSource = dt.DefaultView; gv.DataBind(); } }引用通告此日志的引用通告 URL 是： http://microanty.spaces.live.com/blog/cns!4529DF58DA9D2E9C!1048.trak 引用此项的网络日志
|
|
|
