aspnetpager控件.aspx
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="高效分页aspnetpager控件.aspx.cs" Inherits="MyWebApplication.增删改查.高效分页aspnetpager控件" %>
<%@ Register Assembly="AspNetPager" Namespace="Wuqi.Webdiyer" TagPrefix="webdiyer" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:ObjectDataSource ID="ObjectDataSource1" runat="server"
InsertMethod="Insert" OldValuesParameterFormatString="original_{0}"
SelectMethod="getPagedData"
TypeName="MyWebApplication.增删改查.App_Data.DataSetUserTableAdapters.t_userTableAdapter"
UpdateMethod="DisableUserByID" EnablePaging="True"
SelectCountMethod="QueryCount"
StartRowIndexParameterName="startIndex" MaximumRowsParameterName="pageSize"
OnSelecting="ODS_Selecting">
<InsertParameters>
<asp:Parameter Name="p1" Type="Int32" />
<asp:Parameter Name="p2" Type="String" />
<asp:Parameter Name="p3" Type="Int32" />
<asp:Parameter Name="p4" Type="String" />
</InsertParameters>
<SelectParameters>
<asp:ControlParameter ControlID="AspNetPager1" PropertyName="StartRecordIndex" DefaultValue="0" Name="startIndex" Type="Int32" />
<asp:ControlParameter ControlID="AspNetPager1" PropertyName="PageSize" DefaultValue="10" Name="pageSize" Type="Int32" />
</SelectParameters>
<UpdateParameters>
<asp:Parameter Name="id" Type="Int32" />
</UpdateParameters>
</asp:ObjectDataSource>
</div>
<asp:ListView ID="ListView1" runat="server" DataSourceID="ObjectDataSource1" InsertItemPosition="LastItem">
<AlternatingItemTemplate>
<tr style="">
<td>
<asp:Button ID="EditButton" runat="server" CommandName="Edit" Text="编辑" />
</td>
<td>
<asp:Label ID="idLabel" runat="server" Text='<%# Eval("id") %>' />
</td>
<td>
<asp:Label ID="nameLabel" runat="server" Text='<%# Eval("name") %>' />
</td>
<td>
<asp:Label ID="ageLabel" runat="server" Text='<%# Eval("age") %>' />
</td>
<td>
<asp:Label ID="statusLabel" runat="server" Text='<%# Eval("status") %>' />
</td>
</tr>
</AlternatingItemTemplate>
<EditItemTemplate>
<tr style="">
<td>
<asp:Button ID="UpdateButton" runat="server" CommandName="Update" Text="更新" />
<asp:Button ID="CancelButton" runat="server" CommandName="Cancel" Text="取消" />
</td>
<td>
<asp:TextBox ID="idTextBox" runat="server" Text='<%# Bind("id") %>' />
</td>
<td>
<asp:TextBox ID="nameTextBox" runat="server" Text='<%# Bind("name") %>' />
</td>
<td>
<asp:TextBox ID="ageTextBox" runat="server" Text='<%# Bind("age") %>' />
</td>
<td>
<asp:TextBox ID="statusTextBox" runat="server" Text='<%# Bind("status") %>' />
</td>
</tr>
</EditItemTemplate>
<EmptyDataTemplate>
<table runat="server" style="">
<tr>
<td>未返回数据。</td>
</tr>
</table>
</EmptyDataTemplate>
<InsertItemTemplate>
<tr style="">
<td>
<asp:Button ID="InsertButton" runat="server" CommandName="Insert" Text="插入" />
<asp:Button ID="CancelButton" runat="server" CommandName="Cancel" Text="清除" />
</td>
<td>
<asp:TextBox ID="idTextBox" runat="server" Text='<%# Bind("id") %>' />
</td>
<td>
<asp:TextBox ID="nameTextBox" runat="server" Text='<%# Bind("name") %>' />
</td>
<td>
<asp:TextBox ID="ageTextBox" runat="server" Text='<%# Bind("age") %>' />
</td>
<td>
<asp:TextBox ID="statusTextBox" runat="server" Text='<%# Bind("status") %>' />
</td>
</tr>
</InsertItemTemplate>
<ItemTemplate>
<tr style="">
<td>
<asp:Button ID="EditButton" runat="server" CommandName="Edit" Text="编辑" />
</td>
<td>
<asp:Label ID="idLabel" runat="server" Text='<%# Eval("id") %>' />
</td>
<td>
<asp:Label ID="nameLabel" runat="server" Text='<%# Eval("name") %>' />
</td>
<td>
<asp:Label ID="ageLabel" runat="server" Text='<%# Eval("age") %>' />
</td>
<td>
<asp:Label ID="statusLabel" runat="server" Text='<%# Eval("status") %>' />
</td>
</tr>
</ItemTemplate>
<LayoutTemplate>
<table runat="server">
<tr runat="server">
<td runat="server">
<table id="itemPlaceholderContainer" runat="server" border="0" style="">
<tr runat="server" style="">
<th runat="server"></th>
<th runat="server">id</th>
<th runat="server">name</th>
<th runat="server">age</th>
<th runat="server">status</th>
</tr>
<tr id="itemPlaceholder" runat="server">
</tr>
</table>
</td>
</tr>
<tr runat="server">
<td runat="server" style=""></td>
</tr>
</table>
</LayoutTemplate>
<SelectedItemTemplate>
<tr style="">
<td>
<asp:Button ID="EditButton" runat="server" CommandName="Edit" Text="编辑" />
</td>
<td>
<asp:Label ID="idLabel" runat="server" Text='<%# Eval("id") %>' />
</td>
<td>
<asp:Label ID="nameLabel" runat="server" Text='<%# Eval("name") %>' />
</td>
<td>
<asp:Label ID="ageLabel" runat="server" Text='<%# Eval("age") %>' />
</td>
<td>
<asp:Label ID="statusLabel" runat="server" Text='<%# Eval("status") %>' />
</td>
</tr>
</SelectedItemTemplate>
</asp:ListView>
<webdiyer:AspNetPager ID="AspNetPager1" runat="server" AlwaysShow="true" ShowCustomInfoSection="Left" PageSize="3" ></webdiyer:AspNetPager>
</form>
</body>
</html>
aspnetpager控件.aspx.cs
using MyWebApplication.增删改查.App_Data.DataSetUserTableAdapters;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
namespace MyWebApplication.增删改查
{
public partial class 高效分页aspnetpager控件 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
t_userTableAdapter dal = new t_userTableAdapter();
AspNetPager1.RecordCount = Convert.ToInt32(dal.QueryCount(1,1));
}
}
protected void ODS_Selecting(object sender, ObjectDataSourceSelectingEventArgs e)
{
if (!e.ExecutingSelectCount)
{
e.Arguments.StartRowIndex = AspNetPager1.StartRecordIndex-1;
e.Arguments.MaximumRows = AspNetPager1.PageSize;
}
}
}
}
数据集
QueryCount内容
SELECT COUNT(*) FROM t_user
getPagedData内容
SELECT id, name, age, status
FROM t_user limit @startIndex, @pageSize
注意
1这两个查询都可配参数,即使QueryCount没有用到参数也可配,不然会报asp.net中ObjectDataSource“”未能找到不带参数的非泛型方法“
可能是为了条件查询时翻页用的,所以假装传二个数进去
2
<asp:ControlParameter ControlID="AspNetPager1" PropertyName="StartRecordIndex" DefaultValue="0" Name="startIndex" Type="Int32" />
<asp:ControlParameter ControlID="AspNetPager1" PropertyName="PageSize" DefaultValue="10" Name="pageSize" Type="Int32" />
这里面设置的两个默认值都没有起到作用,不知为何?
每页条数取的是:
<webdiyer:AspNetPager ID="AspNetPager1" runat="server" AlwaysShow="true" ShowCustomInfoSection="Left" PageSize="3" ></webdiyer:AspNetPager>
起始条设的0,可是得到的是1
<asp:ControlParameter ControlID="AspNetPager1" PropertyName="StartRecordIndex"DefaultValue="0" Name="startIndex" Type="Int32" />
因些只能在代码里调整-1
希望有知道的回复一下