我的思想来自孟子E章的例子,资料来源于http://dotnet.aspx.cc/article/b12283de-db20-4322-accc-12724442808a/read.aspx,我只不过将用DataGrid分页改成GridView分页罢了.在Visual Web Developer环境下运行通过.例子如下: <%@ Page Language="C#" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <script runat="server"> protected void Page_Load(object sender, EventArgs e) { btnFirst.Text = "最首页"; btnPrev.Text = "前一页"; btnNext.Text = "下一页"; btnLast.Text = "最后页"; GridView1.DataBind(); ShowPageChangedStatus(); } private void ShowPageChangedStatus() { lblCurrentIndex.Text = "第" + (GridView1.PageIndex + 1).ToString() + "页"; lblPageCount.Text = "总共 " + GridView1.PageCount.ToString() + " 页"; } public void PagerButtonClick(object sender, EventArgs e) { string arg = ((LinkButton)sender).CommandArgument.ToString(); switch (arg) { case "next": if (GridView1.PageIndex < (GridView1.PageCount - 1)) { GridView1.PageIndex += 1; } break; case "prev": if (GridView1.PageIndex > 0) { GridView1.PageIndex -= 1; } break; case "last": GridView1.PageIndex = (GridView1.PageCount - 1); break; default: GridView1.PageIndex = System.Convert.ToInt32(arg); break; } GridView1.DataBind(); ShowPageChangedStatus(); } protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e) { int startIndex; startIndex = GridView1.PageIndex * GridView1.PageSize; GridView1.PageIndex = e.NewPageIndex; GridView1.DataBind(); ShowPageChangedStatus(); } </script> <html xmlns="http://www.w3.org/1999/xhtml" ><head runat="server"> <title>Untitled Page</title></head><body> <form id="form1" runat="server"> <div> <asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False" DataKeyNames="pkey" PagerStyle-HorizontalAlign="Right" DataSourceID="SqlDataSource1" HorizontalAlign="Center" CellPadding="3" PageSize="5" OnPageIndexChanging="GridView1_PageIndexChanging"> <Columns> <asp:BoundField DataField="pkey" HeaderText="部门编号" InsertVisible="False" ReadOnly="True" SortExpression="pkey"> <HeaderStyle BackColor="#C0C0FF" /> </asp:BoundField> <asp:BoundField DataField="departmentName" HeaderText="部门名称" SortExpression="departmentName" > <HeaderStyle BackColor="#C0C0FF" /> </asp:BoundField> <asp:BoundField DataField="previousName" HeaderText="原先名称" SortExpression="previousName" > <HeaderStyle BackColor="#C0C0FF" /> </asp:BoundField> <asp:BoundField DataField="remark" HeaderText="附注" SortExpression="remark" > <HeaderStyle BackColor="#C0C0FF" /> </asp:BoundField> <asp:BoundField DataField="isSubCompany" HeaderText="子公司名" SortExpression="isSubCompany" > <HeaderStyle BackColor="#C0C0FF" /> </asp:BoundField> <asp:CommandField ShowDeleteButton="True" ShowEditButton="True" ShowSelectButton="True" CancelText="取消" DeleteText="删除" EditText="编辑" SelectText="选择" UpdateText="更新" HeaderText="编辑" > <HeaderStyle BackColor="#C0C0FF" /> </asp:CommandField> </Columns> <PagerStyle HorizontalAlign="Right"/> <AlternatingRowStyle BackColor="#eeeeee" /> </asp:GridView> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConflictDetection="CompareAllValues" ConnectionString="<%$ ConnectionStrings:EHRConnectionString %>" DeleteCommand="DELETE FROM [DEPARTMENT] WHERE [pkey] = @original_pkey AND [departmentName] = @original_departmentName AND [previousName] = @original_previousName AND [remark] = @original_remark AND [isSubCompany] = @original_isSubCompany" InsertCommand="INSERT INTO [DEPARTMENT] ([departmentName], [previousName], [remark], [isSubCompany]) VALUES (@departmentName, @previousName, @remark, @isSubCompany)" OldValuesParameterFormatString="original_{0}" SelectCommand="SELECT [pkey], [departmentName], [previousName], [remark], [isSubCompany] FROM [DEPARTMENT]" UpdateCommand="UPDATE [DEPARTMENT] SET [departmentName] = @departmentName, [previousName] = @previousName, [remark] = @remark, [isSubCompany] = @isSubCompany WHERE [pkey] = @original_pkey AND [departmentName] = @original_departmentName AND [previousName] = @original_previousName AND [remark] = @original_remark AND [isSubCompany] = @original_isSubCompany"> <DeleteParameters> <asp:Parameter Name="original_pkey" Type="Int32" /> <asp:Parameter Name="original_departmentName" Type="String" /> <asp:Parameter Name="original_previousName" Type="String" /> <asp:Parameter Name="original_remark" Type="String" /> <asp:Parameter Name="original_isSubCompany" Type="String" /> </DeleteParameters> <UpdateParameters> <asp:Parameter Name="departmentName" Type="String" /> <asp:Parameter Name="previousName" Type="String" /> <asp:Parameter Name="remark" Type="String" /> <asp:Parameter Name="isSubCompany" Type="String" /> <asp:Parameter Name="original_pkey" Type="Int32" /> <asp:Parameter Name="original_departmentName" Type="String" /> <asp:Parameter Name="original_previousName" Type="String" /> <asp:Parameter Name="original_remark" Type="String" /> <asp:Parameter Name="original_isSubCompany" Type="String" /> </UpdateParameters> <InsertParameters> <asp:Parameter Name="departmentName" Type="String" /> <asp:Parameter Name="previousName" Type="String" /> <asp:Parameter Name="remark" Type="String" /> <asp:Parameter Name="isSubCompany" Type="String" /> </InsertParameters> </asp:SqlDataSource> <div style="FONT-SIZE:9pt" align="center"> <asp:label id="lblPageCount" runat="server"></asp:label> <asp:label id="lblCurrentIndex" runat="server"></asp:label> <asp:linkbutton id="btnFirst" onclick="PagerButtonClick" runat="server" Font-size="8pt" ForeColor="navy" CommandArgument="0"></asp:linkbutton> <asp:linkbutton id="btnPrev" onclick="PagerButtonClick" runat="server" Font-size="8pt" ForeColor="navy" CommandArgument="prev"></asp:linkbutton> <asp:linkbutton id="btnNext" onclick="PagerButtonClick" runat="server" Font-size="8pt" ForeColor="navy" CommandArgument="next"></asp:linkbutton> <asp:linkbutton id="btnLast" onclick="PagerButtonClick" runat="server" Font-size="8pt" ForeColor="navy" CommandArgument="last"></asp:linkbutton> </div> </div> </form></body></html>
评论