GridView点击列名进行排序

最新推荐文章于 2021-07-08 00:59:59 发布

copyspaste

最新推荐文章于 2021-07-08 00:59:59 发布

阅读量1k

点赞数

文章标签： string asp server sorting object xhtml

本文链接：https://blog.csdn.net/copyspaste/article/details/7362316

版权

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>
<body>
<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();

}

}