做个类似 专家排行榜的功能

通过客户点击通过数据库计算排行显示示例
//点击视频记录播放次数
 <asp:Literal ID="Literal1" runat="server"></asp:Literal>//播放器设置
 //显示播放器并可以播放视频
  this.Literal1.Text = operateMethod.GetFlashText(link);
  //增加点击率和用户积分
    public void addPlaySum()
    {
        //创建SQL语句，增加视频的点击率
        string sql = "update videoInfo set playSum=playSum+1,monthSum=monthSum+1 where id=" + Request["id"];
        operateData.execSql(sql);
        //创建SQL语句，查询出发布视频会员名
        string sqlSel = "select userName from videoInfo where id=" + Request["id"];
        //获取会员名
        string userName = operateData.getTier(sqlSel);
        //创建SQL语句，增加用户的积分
        string sqlUpd = " update userInfo set sumMark=sumMark+1 where userName='" + userName + "'";
        //执行SQL语句
        operateData.execSql(sqlUpd);    }
//显示会员积分
<table align="center" cellpadding="0" cellspacing="0" height="95" width="381">
                                                        <tr>
                                                            <td>
                                                                <table bgcolor="#999999" border="1" bordercolor="#ffffff" cellpadding="1" cellspacing="1"
                                                                    height="168" width="150">
                                                                    <tr>
                                                                        <td bgcolor="#ffffff" height="166" valign="top" width="141">
                                                                            <img id="uy" alt="" height="166" name="uy" src="<%=img %>" width="141" /></td>
                                                                    </tr>
                                                                </table>
                                                            </td>
                                                            <td class="huise1" style="text-align: left">
                                                                会员名：<%=userName%>
                                                                当前积分：<span class="chengse"><%=sumMark%>
                                                                </span>
                                                                <br />
                                                                昵称：<%=nickName %>
                                                                <br />
                                                                性别：
                                                                <%=sex %>
                                                                <br />
                                                                QQ：<%=qq %>
                                                                <br />
                                                                所在城市：<%=city%>
                                                                <br />
                                                                注册时间：<%=registerDate %>
                                                            </td>
                                                        </tr>
                                                        <tr>
                                                            <td class="huise1" colspan="2">
                                                                <span class="hongcu">个人说明：</span><%=speak %></td>
                                                        </tr>
                                                    </table>
//cs页面处理积分
protected void bindUserInfo()
    {
        //编写SQL语句，查询指定用户的详细信息
        string sqlSel = "select  * from userInfo where userName='" + Request["userName"] +"' ";
        //调用公共类中的getRow方法执行SQL语句并接收返回的SqlDataReader对象
        SqlDataReader sdr = operateData.getRow(sqlSel);
        //读取一条记录
        sdr.Read();
        //获取用户名
        userName = sdr["userName"].ToString();
        //获取用户昵称
        nickName = sdr["nickName"].ToString();
        //获取用户性别
        sex = sdr["sex"].ToString();
        //获取QQ
        qq = sdr["qq"].ToString();
        //获取用户所在城市
        city = sdr["city"].ToString();
        //获取用户留言
        speak = sdr["speak"].ToString();
        //获取用户头像
        img = sdr["img"].ToString();
        //获取用户积分
        sumMark = sdr["sumMark"].ToString();
        //获取注册日期
        registerDate = sdr["registerDate"].ToString();
        sdr.Close();
    }