自行控制GridView的Paging和Sorting

最新推荐文章于 2021-06-04 18:34:05 发布

转载最新推荐文章于 2021-06-04 18:34:05 发布 · 1.3k 阅读

文章标签：

#sorting #object #string #server #asp #null

DotNET 同时被 2 个专栏收录

29 篇文章

订阅专栏

DotNET

22 篇文章

订阅专栏

本文介绍如何在ASP.NET中使用GridView控件实现数据排序和分页功能。通过具体的代码示例，展示了如何根据用户点击列头进行升序或降序排序，并更新GridView的数据源以反映新的排序顺序。此外，还解释了如何处理页面索引更改事件以实现数据分页。

<asp:GridView ID="gridView" OnPageIndexChanging="gridView_PageIndexChanging" OnSorting="gridView_Sorting" runat="server" /> private string ConvertSortDirectionToSql(SortDirection sortDirection) { string newSortDirection = String.Empty; switch (sortDirection) { case SortDirection.Ascending: newSortDirection = "ASC"; break; case SortDirection.Descending: newSortDirection = "DESC"; break; } return newSortDirection; } protected void gridView_PageIndexChanging(object sender, GridViewPageEventArgs e) { gridView.PageIndex = e.NewPageIndex; gridView.DataBind(); } protected void gridView_Sorting(object sender, GridViewSortEventArgs e) { DataTable dataTable = gridView.DataSource as DataTable; if (dataTable != null) { DataView dataView = new DataView(dataTable); dataView.Sort = e.SortExpression + " " + ConvertSortDirectionToSql(e.SortDirection); gridView.DataSource = dataView; gridView.DataBind(); } }