asp.net GridView排序简单实现


前台:
代码

复制代码 代码如下:

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="GridViewSort.aspx.cs" Inherits="GridViewSort" %>
<!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>GridView排序简单实现</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:GridView ID="gdvSort" runat="server" OnSorting="gdvSort_Sorting">
</asp:GridView>
</div>
</form>
</body>
</html>

后台:

代码
复制代码 代码如下:

using System;
using System.Data;
using System.Configuration;
using System.Collections;
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;

public partial class GridViewSort : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ViewState["SortOrder"] = "PID";
ViewState["OrderDire"] = "Desc";
Bind();
}
}
private void Bind()
{
gdvSort.AllowSorting = true;
DataView dv = getDt().DefaultView;
dv.Sort = (string)ViewState["SortOrder"] + " " + (string)ViewState["OrderDire"];
gdvSort.DataSource = dv;
gdvSort.DataBind();
}
/// <summary>
/// 连数据库麻烦,直接构造一个DataTable
/// </summary>
/// <returns></returns>
private DataTable getDt()
{
DataTable dt = new DataTable();
dt.Columns.Add("PID", typeof(System.Int32));
dt.Columns.Add("UserName", typeof(System.String));
for (int i = 0; i < 10; i++)
{
DataRow dr = dt.NewRow();
dr["PID"] = i;
dr["UserName"] = "姓名" + i;
dt.Rows.Add(dr);
}
return dt;
}
protected void gdvSort_Sorting(object sender, GridViewSortEventArgs e)
{
string sPage = e.SortExpression;
if (ViewState["SortOrder"].ToString() == sPage)
{
if (ViewState["OrderDire"].ToString() == "Desc")
{
ViewState["OrderDire"] = "Asc";
}
else
{
ViewState["OrderDire"] = "Desc";
}
}
else
ViewState["SortOrder"] = e.SortExpression;
Bind();
}
}



相关阅读:
初学者必读:精讲SQL中的时间计算语句
FSO一些代码
Oracle 动态视图
JSP过滤器实现---论坛不文明语过滤功能
IE和火狐中模仿Click事件及提交到新窗口总结(asp.net)
CSS教程:认真学习haslayout
如何有效利用系统中自带的记事本功能
关于 ASP 应用程序
javascript实现网页跳转的方法
vbs中实现启动两个应用程序,一直等到其中一个程序结束,然后关闭另一个?
JavaScript blog式日历控件新算法
php抓即时股票信息
SqlServer 序号列的实现方法
Optimizer与Debugger兼容性问题的解决方法
快速导航

Copyright © 2016 phpStudy | 皖ICP备18014864号-4