在aps.net中多数据绑定的控件很多，论功能来说，应该属DataGrid最为齐全，但它没有提供现成的显示记录序号的功能，不过我们可以通过它所带的一些参数来间接得到序号，下面来看看怎样得到和显示序号值计算方式如下：

(1)在后台

DataGrid.CurrentPageIndex * DataGrid.PageSize + e.Item.ItemIndex + 1

(2)在前台

DataGrid1.CurrentPageIndex * DataGrid1.PageSize + Container.ItemIndex + 1

说明：

e表示System.Web.UI.WebControls.DataGridItemEventArgs参数类的实例；

DataGrid1这里表示前台的一个实例；

DataGrid.CurrentPageIndex：获取或设置当前显示页的索引；

DataGrid.PageSize ：获取或设置要在 DataGrid 控件的单页上显示的项数。

下面我使用了4种方法来在前台显示序号，不过都是围绕上面的计算式展开。

（1）         使用DataGrid的ItemCreated设置值，而前台的单元格可以是绑定列或者模板列(包括空模板)；

（2）         使用DataGrid的ItemDataBound设置值，而前台的单元格可以是绑定列或者模板列(包括空模板)；

（3）         在前台直接绑定计算表达式；

（4）         在后台类中编写方法计算表达式由前台页面类继承调用。

备注：在数据库中获取数据时设置额外的序号列这里不做讨论，我认为这是最糟糕的实现方法。

下面以获取Northwind数据库的Customers表的数据为列，显示如下：

下面是WebFormPaging.aspx文件代码，

<%@ Page language="c#" Codebehind="WebFormPaging.aspx.cs" AutoEventWireup="false" Inherits="AspnetPaging.WebForm1" %>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >

<HTML>

         <HEAD>

                   <title>WebForm1</title>

                   <meta content="Microsoft Visual Studio .NET 7.1" name="GENERATOR">

                   <meta content="C#" name="CODE_LANGUAGE">

                   <meta content="JavaScript" name="vs_defaultClientScript">

                   <meta content="http://schemas.microsoft.com/intellisense/ie5" name="vs_targetSchema">

         </HEAD>

         <body>

                   <form id="Form1" method="post" runat="server">

                            <TABLE id="Table1" cellSpacing="1" cellPadding="1" width="400" align="center" border="1">

                                     <TR>

                                               <TD><asp:datagrid id="DataGrid1" runat="server" AutoGenerateColumns="False" Width="100%" AllowPaging="True">

                                                                 <Columns>

                                                                           <asp:BoundColumn HeaderText="序号1"></asp:BoundColumn>

                                                                           <asp:TemplateColumn HeaderText="序号2"></asp:TemplateColumn>

                                                                           <asp:TemplateColumn HeaderText="序号3">

                                                                                    <ItemTemplate>

                                                                                             <asp:Label ID="itemIndex" runat="server"></asp:Label>

                                                                                    </ItemTemplate>

                                                                           </asp:TemplateColumn>

                                                                           <asp:TemplateColumn HeaderText="序号4">

                                                                                    <ItemTemplate>

                                                                                             <%# (DataGrid1.CurrentPageIndex * DataGrid1.PageSize + Container.ItemIndex + 1) %>

                                                                                    </ItemTemplate>

                                                                           </asp:TemplateColumn>

                                                                           <asp:TemplateColumn HeaderText="序号5">

                                                                                    <ItemTemplate>

                                                                                             <%# GetRecordIndex( Container.ItemIndex ) %>

                                                                                    </ItemTemplate>

                                                                           </asp:TemplateColumn>

                                                                           <asp:BoundColumn DataField="CustomerID" HeaderText="CustomerID"></asp:BoundColumn>

                                                                 </Columns>

                                                                 <PagerStyle Mode="NumericPages"></PagerStyle>

                                                        </asp:datagrid></TD>

                                     </TR>

                                     <TR>

                                               <TD></TD>

                                     </TR>

                                     <TR>

                                               <TD></TD>

                                     </TR>

                            </TABLE>

                   </form>

         </body>

</HTML>

 

首页 | 1 | 2 | 3 | 尾页  共 3 页