datagrid分页排序问题

[zhangqiushui]

我用datagrid来显示数据库中的数据，既可以点击列标题来排序，又可以分页（通过点击下一页，上一页）现在的问题是，当我在某页单击列标题排序后，点击下一页时的datagrid中的数据没有排序了。
//分页代码
private void datResult_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
{



DataTable dt=(DataTable)Session["SortTable"];

DataView dv=new DataView(dt);
datResult.DataSource=dv;
datResult.CurrentPageIndex=e.NewPageIndex;
datResult.DataBind();
}
//排序代码
private void datResult_SortCommand(object source, System.Web.UI.WebControls.DataGridSortCommandEventArgs e)
{
DataTable dt=(DataTable)Session["SortTable"];
DataView dv=new DataView(dt);
dv.Sort=e.SortExpression;
datResult.CurrentPageIndex=0;
datResult.DataSource=dv;

datResult.DataBind();
}

[噯卟釋手]

这方面的代码太多了吧 搜搜看 感觉许多都是用存储过程来实现滴

[xiaojunrouton]

private string SortDirection
{
get
{
if(ViewState["SortDirection"] == null)
return "";
return ViewState["SortDirection"] as string;
}
set
{
ViewState["SortDirection"] = value;
}

}


//分页代码
private void datResult_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
{



DataTable dt=(DataTable)Session["SortTable"];

DataView dv=new DataView(dt);
dv.sort = "";
dv.sort = SortDirection;
datResult.DataSource=dv;
datResult.CurrentPageIndex=e.NewPageIndex;
datResult.DataBind();
}
//排序代码
private void datResult_SortCommand(object source, System.Web.UI.WebControls.DataGridSortCommandEventArgs e)
{
DataTable dt=(DataTable)Session["SortTable"];
DataView dv=new DataView(dt);
dv.Sort=e.SortExpression;
datResult.CurrentPageIndex=0;
datResult.DataSource=dv;

datResult.DataBind();
}