日期:2014-05-20  浏览次数:20496 次

一个有点难度的排序问题
关键代码如下:
------------------------------------------
<asp:TemplateColumn   HeaderText= "总积分 ">
<HeaderStyle   Width= "50px "> </HeaderStyle>
<ItemTemplate>
<%#   numm(DataBinder.Eval(Container.DataItem,   "hy_name ").ToString())   %>
</ItemTemplate>
</asp:TemplateColumn>
----------------------------------
string   strSel1   =   "select   top   6   *   from   huiyuan   ORDER   BY   “按积分大小来排序”   DESC ";
-----------------------------------
protected   string   numm(string   hy_name)
{
.....
.....
string   mySel1= "SELECT   sum(d_fs)   as   iCount   from   defen   where   hy_name= ' "+hy_name+ " ' ";
OleDbCommand   myCmd11=new   OleDbCommand(mySel1,MyConnection);
myCmd11.Connection.Open();
OleDbDataReader   Dr11=myCmd11.ExecuteReader();
Dr11.Read();
string   Count1=Dr11[ "iCount "].ToString();
Dr11.Close();
myCmd11.Connection.Close();
return   Count1;
}
-----------------------------------------------
我的问题是:“按积分大小来排序”怎么实现?意思是得到的Count1在huiyuan表里按从大到小排序,如何做到?

------解决方案--------------------
???