GridView中实现并列排名的例子[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>

时间： 2024-07-28 16:54:13

GridView中实现并列排名的例子[access版]

GridView中实现并列排名的例子[access版]的相关文章

GridView中实现并列排名的例子 SQL Server版

asp.net中获取新增加记录的ID Access版_实用技巧

ASP.NET2.0中Gridview中数据操作技巧

提高在google中排名的重点(精简版)

代码-Android中GridView中当我删除某一个图片时图片缓存清空,图片位置上显示背景图

Gridview中如何对IP地址列排序

GridView中日期不显示时分秒的完美解决方法_实用技巧

把存入数据库中的图片取出来,显示在GridView中是没有问题的,但是要用marquee来滚动显示从数据库中读出的图片怎么办?

gridview中的checkbox选择