本文介绍了一个ASP.NET应用程序中实现数据分页的方法，并详细解释了如何通过按钮和页面索引更改事件来控制数据网格的当前显示页面，同时展示了如何更新页面状态信息。
private void Page_Load(object sender, System.EventArgs e)
...{
OpenDatabase(); BindGrid(); this.count.Text = "您搜索出 "+ds.Tables[0].Rows.Count.ToString()+" 条记录";
} private void OpenDatabase() ...{ cn = new SqlConnection(C.ConfigurationSettings.AppSettings[0]); cn.Open(); } public void BindGrid() ...{ ds = new DataSet(); SqlDataAdapter da = new SqlDataAdapter(sql,cn); da.Fill(ds,"Document"); this.Datagrid2.DataSource = ds.Tables["Document"].DefaultView; this.Datagrid2.DataBind(); ShowStats(); } private void ShowStats() ...{ lblCurrentIndex.Text = "第 " + (DataGrid2.CurrentPageIndex + 1).ToString() + " 页"; lblPageCount.Text = "总共 " + DataGrid2.PageCount.ToString() + " 页"; } //上页下页最前最后按钮事件private void Button_Click(object sender, System.Web.UI.ImageClickEventArgs e) ...{ string arg = ((ImageButton)sender).CommandArgument.ToString(); switch(arg)
...{ case ("first"): DataGrid2.CurrentPageIndex = 0; break; case ("prev"): if(DataGrid2.CurrentPageIndex>0) ...{ DataGrid2.CurrentPageIndex--; 
} break; case ("next"): if(DataGrid2.CurrentPageIndex<(DataGrid2.PageCount-1)) ...{ DataGrid2.CurrentPageIndex++; } break; case ("last"): DataGrid2.CurrentPageIndex = DataGrid2.PageCount-1; break; default: DataGrid2.CurrentPageIndex = Convert.ToInt32(arg); break; } BindGrid(); this.ShowStats(); }private void OnPageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e) ...{ int startIndex ; startIndex = DataGrid2.CurrentPageIndex * DataGrid2.PageSize; DataGrid2.CurrentPageIndex = e.NewPageIndex; BindGrid(); ShowStats(); }//按钮go的代码private void go_Click(object sender, System.Web.UI.ImageClickEventArgs e) ...{ if(to.Text.Trim()!="") ...{ int index=Int32.Parse(to.Text.Trim())-1; if(index>=0&&index<DataGrid2.PageCount) ...{ DataGrid2.CurrentPageIndex=index; } } BindGrid(); }//在窗体设计器生成的代码中加入 this.First.Click += new System.Web.UI.ImageClickEventHandler(this.Button_Click); this.Prev.Click += new System.Web.UI.ImageClickEventHandler(this.Button_Click); this.Next.Click += new System.Web.UI.ImageClickEventHandler(this.Button_Click); this.Last.Click += new System.Web.UI.ImageClickEventHandler(this.Button_Click); this.go.Click += new System.Web.UI.ImageClickEventHandler(this.go_Click); this.DataGrid2.PageIndexChanged += new System.Web.UI.WebControls.DataGridPageChangedEventHandler(this.OnPageIndexChanged);
扫一扫
1429
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
