gridview正反向排序

来源：互联网发布：软件测试分析报告编辑：程序博客网时间：2024/04/29 17:41

后台：

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.Data.SqlClient;

public partial class _Default : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

ViewState["sortExp"] = "CLASS_ID";

ViewState["sortDir"] = "Desc";

GetData();

}

private void GetData()

{

string str = "data source=172.17.254.34;initial catalog=META_DWH;persist security info=False;user id=test;pwd=test";

SqlConnection cn = new SqlConnection(str);

SqlDataAdapter da = new SqlDataAdapter("select * from M_CLASS1_bk", cn);

DataSet ds = new DataSet();

da.Fill(ds);

DataView dv = new DataView(ds.Tables[0]);

string sort =ViewState["sortExp"] + " " +ViewState["sortDir"];

dv.Sort = sort;

GridView1.DataSource = dv;

GridView1.DataBind();

}

protected void GridView1_Sorting(object sender, GridViewSortEventArgs e)

{

string sPage = e.SortExpression;

if (ViewState["sortExp"].ToString() == sPage)

{

if (ViewState["sortDir"].ToString() == "Desc")

ViewState["sortDir"] = "ASC";

else

ViewState["sortDir"] = "Desc";

}

else

{

ViewState["sortExp"] = e.SortExpression;

}

GetData();

}

前台：

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

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<title>無題のページ</title>

</head>

<body>

<div>

</div>

<asp:GridView ID="GridView1" runat="server" AllowSorting="True" AutoGenerateColumns="False" OnSorting="GridView1_Sorting" >

<asp:BoundField DataField="CLASS_ID" HeaderText="CLASS_ID" SortExpression="CLASS_ID" />

<asp:BoundField DataField="CLASS_NM" HeaderText="B" SortExpression="CLASS_NM" />

<asp:BoundField DataField="UPDATETIME" HeaderText="C"/>

</Columns>

</asp:GridView>

</form>

</body>

</html>