一个有点难度的排序问题
关键代码如下:
------------------------------------------
<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表里按从大到小排序,如何做到?
[解决办法]
???