GridView中实现并列排名的例子

ChinaItLab

孟宪会

2007-6-15

保存本文

推荐给好友

收藏本页

Access数据库版本

<%@ Page Language="C#" AutoEventWireup="true" Debug="true" %>
<%@ Import Namespace="System.Data" %>
<script runat="server">
public int TrapezoidIndex = 1;
int LastNumer = 0;
protected void Page_Load( object sender, EventArgs e )
{
    //ASPNET20Book.mdb数据库参见《ASP.NET 2.0应用开发技术》一书的光盘
    string ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\ASPNET20Book.mdb;Persist Security Info=True";
    System.Data.OleDb.OleDbConnection cn = new System.Data.OleDb.OleDbConnection(ConnectionString);
    cn.Open();
    string sql = "select * from [Score] Order BY Shuxue DESC";
    System.Data.OleDb.OleDbCommand cmd = new System.Data.OleDb.OleDbCommand(sql, cn);
    System.Data.OleDb.OleDbDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
    GridView1.DataSource = dr;
    GridView1.DataBind();
    dr.Close();
    cmd.Dispose();
    cn.Dispose();
}

protected void GridView1_RowCreated( object sender, GridViewRowEventArgs e )
{
    if (e.Row.RowType == DataControlRowType.DataRow)
    {
      System.Data.Common.DbDataRecord db = (System.Data.Common.DbDataRecord)e.Row.DataItem;
      int Shuxue = Int32.Parse(db["Shuxue"].ToString());
      if (e.Row.RowIndex == 0)
      {
        LastNumer = Shuxue;
      }
      if (LastNumer != Shuxue)
      {
        TrapezoidIndex = e.Row.RowIndex + 1;
      }
      LastNumer = Shuxue;
    }
}
</script>

<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
<title>GridView并列排名的例子</title>
</head>
<body>
<form id="form1" runat="server">
    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false" OnRowCreated="GridView1_RowCreated">
      <Columns>
        <asp:TemplateField HeaderText="数据序号">
          <ItemTemplate>
            <%#Container.DataItemIndex + 1%>
          </ItemTemplate>
        </asp:TemplateField>
        <asp:TemplateField HeaderText="学生姓名">
          <ItemTemplate>
            <%#Eval("UserName")%>
          </ItemTemplate>
        </asp:TemplateField>
        <asp:TemplateField HeaderText="数学">
          <ItemTemplate>
            <%#Eval("Shuxue")%>
          </ItemTemplate>
        </asp:TemplateField>
        <asp:TemplateField HeaderText="排名">
          <ItemTemplate>
            <%#TrapezoidIndex%>
          </ItemTemplate>
        </asp:TemplateField>
      </Columns>
    </asp:GridView>
</form>
</body>
</html>

[1] [2] 下一页

【责编:Peng】