1.页面文件:
需要对GridView启用AllowSorting、设置OnSorting事件,对需要排序的列设定SortExpression属性。
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" BackColor="Blue"
BorderColor="#999999" BorderStyle="None" BorderWidth="1px" CellPadding="3" GridLines="Vertical"
Width="98%" AllowSorting="True" OnSorting="GridView1_Sorting">
<FooterStyle BackColor="#CCCCCC" ForeColor="Black" />
<Columns>
<asp:BoundField HeaderText="Text1" DataField="Column1" SortExpression="Column1"/>
<asp:BoundField HeaderText="Text2" DataField="Column2" SortExpression="Column2"/>
<asp:BoundField HeaderText="Text3" DataField="Column3" SortExpression="Column3"/>
</Columns>
2.后台文件:
一般排序都是按string类型排序的,如果需要按数字大小等进行排序
如果这个DataTable是自己手工创建的,请指定其数据类型:
dt.Columns.Add("columnname",typeof(int));
如果这个DataTable是从数据库中取出,那么就需要在sql语句中做一些处理,把它转换成数字型:
select convert(column,int) column from table1
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 admin_OrderAnalyse : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
// 设定初始排序参数值
this.GridView1.Attributes.Add("SortExpression", "id");
this.GridView1.Attributes.Add("SortDirection", "ASC");
// 绑定数据源到GridView
this.BindGridView();
}
}
protected void GridView1_Sorting(object sender, GridViewSortEventArgs e)
{
//从事件参数获取排序数据列
string sortExpression = e.SortExpression.ToString();
//假定为排序方向为“顺序”
string sortDirection = "ASC";
//“ASC”与事件参数获取到的排序方向进行比较,进行GridView排序方向参数的修改
if (sortExpression == this.GridView1.Attributes["SortExpression"])
{
//获得下一次的排序状态
sortDirection = (this.GridView1.Attributes["SortDirection"].ToString() == sortDirection ? "DESC" : "ASC");
// 重新设定GridView排序数据列及排序方向程序开
this.GridView1.Attributes["SortExpression"] = sortExpression;
this.GridView1.Attributes["SortDirection"] = sortDirection;
this.BindGridView();
}
}
/// <summary>
/// 绑定到GridView
/// </summary>
private void BindGridView()
{
// 获取GridView排序数据列及排序方向
string sortExpression = this.GridView1.Attributes["SortExpression"];
string sortDirection = this.GridView1.Attributes["SortDirection"];
// 调用业务数据获取方法
DataTable dt= this.BindDt();
// 根据GridView排序数据列及排序方向设置显示的默认数据视图
if ((!string.IsNullOrEmpty(sortExpression)) && (!string.IsNullOrEmpty(sortDirection)))
{
dtBind.DefaultView.Sort = string.Format("{0} {1}", sortExpression, sortDirection);
}
// GridView绑定并显示数据
this.GridView1.DataSource = dt;
this.GridView1.DataBind();
}
DataTable BindDt()
{
DataTable dt = new DataTable();
dto.Columns.Add("XXX");
dto.Columns.Add("XXX");
dto.Columns.Add("XXX",typeof(int));
DataRow dr = dto.NewRow();
dr["XXX"] =
dr["XXX"] =
dr["XXX"] =
dto.Rows.Add(dr);
return dt;
}
}