嘿,亲!知识可是无价之宝呢,但咱这精心整理的资料也耗费了不少心血呀。小小地破费一下,绝对物超所值哦!如有下载和支付问题,请联系我们QQ(微信同号):78630559
本次赞助数额为: 2 元微信扫码支付:2 元
请留下您的邮箱,我们将在2小时内将文件发到您的邮箱
需要在web.config中修改数据库连接串,然后如果本地没有northwind数据库,请附加northwind数据库,即可测试
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindPage(string.Empty);
}
}
private void BindPage(string content)
{
SinoHelper.PageInfo info = new SinoHelper.PageInfo();
info.PageSize = 5;
info.RepeaterUniqueID = rpt.UniqueID;
info.TableName = "Orders";
info.Fields = "OrderID,CustomerID,ShipCity";
info.IdentityField = "OrderID";
info.Content = content;
AjaxPager1.Info = info;
AjaxPager1.BindData();
}
protected void Button1_Click(object sender, EventArgs e)
{
if (!TextBox1.IsEmpty())
{
BindPage("ShipCity like '%{0}%'".FormatWith(TextBox1.TText()));
}
}
----------------------------------------------------------------------------------------------------------html部分
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="AjaxPager._Default" %>
<%@ Register Assembly="Helper" Namespace="SinoHelper" TagPrefix="pager" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>无标题页</title>
</head>
<body style="font-size:12px;">
<form id="form1" runat="server">
ShipCity:<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
<asp:Button ID="Button1"
runat="server" Text="Search" onclick="Button1_Click" />
<div id="AjaxData">
<asp:Repeater ID="rpt" runat="server">
<HeaderTemplate>
<table style="width:600px;">
<tr>
<th>
OrderID
</th>
<th>
CustomerID
</th>
<th>
ShipCity
</th>
</tr>
</HeaderTemplate>
<ItemTemplate>
<tr>
<td>
<%# Eval("OrderID")%>
</td>
<td>
<%# Eval("CustomerID")%>
</td>
<td>
<%# Eval("ShipCity")%>
</td>
</tr>
</ItemTemplate>
<FooterTemplate>
</table>
</FooterTemplate>
</asp:Repeater>
</div>
<pager:AjaxPager ID="AjaxPager1" Width="600" runat="server"/>
</form>
</body>
</html>