数据是从视图里读出来的, 视图中已排序, 但数据绑定就是不排序, 请问应该如何解决? 在线等.
using (DataSet ds = SqlHelper.ExecuteDataset(WebConfig.DBWWW, CommandType.Text, sqlStrGetList))
{
DataView dv = ds.Tables[0].DefaultView;
dv.Sort = "DownCounts DESC, Hits DESC";
objPds.DataSource = dv;
objPds.AllowPaging = true;
objPds.PageSize = 15; objPds.CurrentPageIndex = CurPage - 1;
lblCurrentPage.Text = "当前页:" + CurPage.ToString(); if (!objPds.IsFirstPage)
{
lnkPrev.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage - 1);
}
if (!objPds.IsLastPage)
{
lnkNext.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage + 1);
}
lnkFirst.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=1";
lnkLast.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + (objPds.PageCount - 1).ToString();
rptList.DataSource = objPds;
rptList.DataBind();
}
using (DataSet ds = SqlHelper.ExecuteDataset(WebConfig.DBWWW, CommandType.Text, sqlStrGetList))
{
DataView dv = ds.Tables[0].DefaultView;
dv.Sort = "DownCounts DESC, Hits DESC";
objPds.DataSource = dv;
objPds.AllowPaging = true;
objPds.PageSize = 15; objPds.CurrentPageIndex = CurPage - 1;
lblCurrentPage.Text = "当前页:" + CurPage.ToString(); if (!objPds.IsFirstPage)
{
lnkPrev.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage - 1);
}
if (!objPds.IsLastPage)
{
lnkNext.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage + 1);
}
lnkFirst.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=1";
lnkLast.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + (objPds.PageCount - 1).ToString();
rptList.DataSource = objPds;
rptList.DataBind();
}
gvwHitsList.DataSource = dv;
gvwHitsList.DataBind();直接就排好序了 ...
Gridview 未做任何设置,
http://lovecherry.cnblogs.com/lovecherry/archive/2006/07/02/440840.html