GridView点击列名进行排序_gridview控件单击列名进行排序

相关文章推荐

严肃的面包 · Google Earth ...· 1 年前 ·

被表白的莴苣 · 助力建设数字孟加拉，中铁国际集团孟加拉国家数 ...· 1 年前 ·

善良的番茄 · 乐乎解密，长租公寓行业“怎么挣钱”· 1 年前 ·

有爱心的毛衣 · 央视曝光“喀纳斯湖水怪”，看长度或超百米，真 ...· 1 年前 ·

逃课的滑板 · 易安音乐社漫画｜官方在线漫画全集-快看漫画· 1 年前 ·

GridView2.aspx

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="GridView2.aspx.cs" Inherits="_Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>无标题页</title>
</head>
<form id="form1" runat="server">
 
<asp:GridView ID="GridView3" runat="server" AllowPaging="True" AutoGenerateColumns="False"
Height="174px" PageSize="5" Width="782px" OnPageIndexChanging="GridView3_PageIndexChanging" AllowSorting="True" OnSorting="GridView3_Sorting">
<PagerSettings Mode="NextPreviousFirstLast" PageButtonCount="3" />
<Columns>
<asp:BoundField DataField="OrderID" HeaderText="OrderID" SortExpression="OrderID" />
<asp:BoundField DataField="CustomerID" HeaderText="CustomerID" SortExpression="CustomerID" >
<ItemStyle Wrap="False" />
</asp:BoundField>
<asp:BoundField DataField="EmployeeID" HeaderText="EmployeeID" SortExpression="EmployeeID" >
<ItemStyle Wrap="False" />
</asp:BoundField>
<asp:BoundField DataField="OrderDate" DataFormatString="{0:R}" HeaderText="OrderDate" SortExpression="OrderDate" >
<ItemStyle Wrap="False" />
</asp:BoundField>
<asp:BoundField DataField="RequiredDate" DataFormatString="{0:yyyy年MM月dd日}" HeaderText="RequiredDate" SortExpression="RequiredDate" >
<ItemStyle Wrap="False" />
</asp:BoundField>
<asp:BoundField DataField="ShipName" HeaderText="ShipName" SortExpression="ShipName" >
<ItemStyle Wrap="False" />
</asp:BoundField>
</Columns>
<PagerTemplate>
<asp:LinkButton ID="LinkButton2" runat="server" CommandArgument="First" CommandName="Page">首页</asp:LinkButton>
<asp:LinkButton ID="LinkButton3" runat="server" CommandArgument="Prev" CommandName="Page">上一页</asp:LinkButton>
<asp:LinkButton ID="LinkButton4" runat="server" CommandArgument="Next" CommandName="Page">下一页</asp:LinkButton>
<asp:LinkButton ID="LinkButton5" runat="server" CommandArgument="Last" CommandName="Page">末页</asp:LinkButton>
 
</PagerTemplate>
<PagerStyle BackColor="Cornsilk" BorderColor="#C0FFFF" BorderStyle="Inset" />
</asp:GridView>
</form>
</body>

</html>

GridView2.aspx.cs

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

using System.Collections.Generic;
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
private DataTable getDataTable()
{
SqlDataAdapter sda = new SqlDataAdapter("select * from orders", "server=.;database=Northwind;uid=sa;pwd=");
DataTable dt = new DataTable();
sda.Fill(dt);
return dt;
}
private void bind()
{
DataView dvTmp=getDataTable().DefaultView;
dvTmp.Sort = "OrderID";
GridView3.DataSource = dvTmp;
GridView3.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ViewState["currentPageIndex"] = 0;
SortGridView("OrderID", "ASC");
//记录每一个列的排序状态
IDictionary<string, string> idic = new Dictionary<string, string>();
idic.Add(new KeyValuePair<string, string>("OrderID", "ASC"));
idic.Add(new KeyValuePair<string, string>("CustomerID", "ASC"));
idic.Add(new KeyValuePair<string, string>("EmployeeID", "ASC"));
idic.Add(new KeyValuePair<string, string>("OrderDate", "ASC"));
idic.Add(new KeyValuePair<string, string>("RequiredDate", "ASC"));
idic.Add(new KeyValuePair<string, string>("ShipName", "ASC"));
ViewState.Add("sortIDic", idic);
GridView3.Attributes.Add("sortExpression", "OrderID");
GridView3.Attributes.Add("sortDirection", "ASC");
}
}

protected void GridView3_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
if (GridView3.EditIndex != -1 || e.NewPageIndex == -1 || e.NewPageIndex == GridView3.PageCount+1)
{
e.Cancel = true;
return;
}
GridView3.PageIndex = e.NewPageIndex;
SortGridView(GridView3.Attributes["sortExpression"], GridView3.Attributes["sortDirection"]);
}
protected void GridView3_Sorting(object sender, GridViewSortEventArgs e)
{
string sortExpression = e.SortExpression;
IDictionary<string, string> idic = ViewState["sortIDic"] as IDictionary<string, string>;
string sortDirection = idic[sortExpression];
sortDirection = (sortDirection == "ASC" ? "DESC" : "ASC");
idic[sortExpression] = sortDirection;
ViewState["sortIDic"] = idic;
SortGridView(sortExpression, sortDirection);

GridView3.Attributes["sortExpression"] = sortExpression;
GridView3.Attributes["sortDirection"] = sortDirection;
}
private void SortGridView(string sortExpression, string direction)
{
DataTable dt = getDataTable();
DataView dv = new DataView(dt);
dv.Sort = sortExpression +" "+ direction;
GridView3.DataSource = dv;
GridView3.DataBind();

}

}

GridView2.aspx 无标题页   Height="174px" PageSize="5" Width="782px" OnPageIndexChanging="GridView3_PageIndexChanging" AllowSorting="Tr

gridview 如果使用sqldatasource绑定数据集的话分页只需将 gridview 属性设置为 Allow Sorting ="True" 即可，但是如果采用其它数据源绑定属性 AutoGenerateColumns 如果设置为false 那么上面的排序方法则行不通。必须自定义排序。页面 gridview 设置如下：后台cs代码重点步骤：自定义

最近做一个项目需要点击列名 进行排序 功能,并且要在分页后还能排序。自己琢磨这就写了一个，废话不多说贴出效果图如图可以点击列名 进行排序 ，点击第一下为升序第二下则为降序说下实现思路 1 gridview 自带的有排序功能，但如果是自己绑定数据源的话就不怎么好用了所以我们要自己写上排序事件 < asp : GridView ID="GvList" runat=" server " Aut...

protected void GridView _ Sorting ( object sender, GridView SortEventArgs e) string sPage = e.SortExpression; if(ViewState["SortOrder"].To String ()== sPage)

关于 GridView 列头点击排序做 ASP .NET Web项目开发，经常会和 GridView 打交道，免不了会根据需求要有列头点击排序的功能，在网上看了很多资料都没有把实例讲全，下面以linq原生语法完成点击列头排序实例： 1）在页面源码中设置Allow Sorting 属性为True并增加On Sorting 事件，以及在绑定列中增加对应的SortExpression属性，如下图：