给个排序的范例:
OleDbConnection MyConn;
public void Page_Load(Object src,EventArgs e)
{
//连接语句
string MyConnString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source="+Server.MapPath(".")+"..\\DataBase\\db1.mdb;";
MyConn = new OleDbConnection(MyConnString);
MyConn.Open(); if(!Page.IsPostBack)
{
ViewState["SortField"] = "Name";////////////////////
BindGrid();
}
}public void BindGrid()
{
DataView dv = (DataView)CreateTable();
dv.Sort = (string)ViewState["SortField"] + " DESC";/////////
score.DataSource = dv;
score.DataBind();
}public void DataGrid_Sort(Object sender,DataGridSortCommandEventArgs e)
{
ViewState["SortField"] = (string)e.SortExpression;////////////////
BindGrid();
}<asp:DataGrid id="score" runat="server"
HeaderStyle-BackColor="#aaaadd"
AlternatingItemStyle-BackColor="#eeeeee"
AutoGenerateColumns="False"
AllowSorting="True"           ///////////////////////////////
OnSortCommand="DataGrid_Sort"        ///////////////////////
>