using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;public partial class _Default : System.Web.UI.Page
{
SqlConnection sqlconn;
string sqlstr = "data source=localhost;database=shop;Uid=sa;Pwd=admin";
public void Page_Load(Object src, EventArgs e)
{
this.bind();
}
public void bind()
{
int curpage = Convert.ToInt32(this.Label1.Text);
Response.Write("a");
PagedDataSource ps = new PagedDataSource();
sqlconn = new SqlConnection(sqlstr);
sqlconn.Open();
string sql = "select top 5 * from book";
SqlDataAdapter MyAdapter = new SqlDataAdapter(sql, sqlstr);
DataSet ds = new DataSet();
MyAdapter.Fill(ds, "book");
ps.DataSource = ds.Tables["book"].DefaultView;
ps.AllowPaging = true; //是否可以分页
ps.PageSize = 2; //显示的数量
ps.CurrentPageIndex = curpage - 1; //取得当前页的页码
this.LinkButton1.Enabled = true;
this.LinkButton2.Enabled = true;
this.LinkButton3.Enabled = true;
this.LinkButton4.Enabled = true;
if (curpage == 1)
{
this.LinkButton1.Enabled = false;//不显示第一页按钮
this.LinkButton2.Enabled = false;//不显示上一页按钮
}
if (curpage == ps.PageCount)
{
this.LinkButton3.Enabled = false;//不显示下一页
this.LinkButton4.Enabled = false;//不显示最后一页
}
this.Label2.Text = Convert.ToString(ps.PageCount);
Repeater1.DataSource = ps;
Repeater1.DataBind();
sqlconn.Close();
}
protected void LinkButton1_Click(object sender, EventArgs e)
{
this.Label1.Text = "1";
this.bind();
}
protected void LinkButton2_Click(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
this.Label1.Text = Convert.ToString(Convert.ToInt32(this.Label1.Text) - 1);
this.bind();
}
}
protected void LinkButton3_Click(object sender, EventArgs e)
{
this.Label1.Text = Convert.ToString(Convert.ToInt32(this.Label1.Text) + 1);
this.bind();
}
protected void LinkButton4_Click(object sender, EventArgs e)
{
this.Label1.Text = this.Label2.Text;
this.bind();
}
}<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %><!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>
<form id="form1" runat="server">
<div>
<table style="width: 600px; height: 58px;">
<tr>
<td style="width: 350px; " align="center">书名</td>
<td style="width: 100px; " align="center">作者</td>
<td style="width: 150px; " align="center">出版社</td>
</tr>
</table>
<asp:Repeater ID="Repeater1" runat="server">
<ItemTemplate>
<table style="width: 600px; height: 30px;">
<tr>
<td style="width: 350px; " align="center">
<asp:Label ID="Label1" runat="server" Text='<%# DataBinder.Eval(Container.DataItem,"book_name") %>' ></asp:Label></td>
<td style="width: 100px; " align="center">
<asp:Label ID="Label2" runat="server" Text='<%# DataBinder.Eval(Container.DataItem,"writer") %>'></asp:Label></td>
<td style="width: 150px;" align="center">
<asp:Label ID="Label3" runat="server" Text='<%# DataBinder.Eval(Container.DataItem,"press") %>'></asp:Label></td>
</tr>
</table>
</ItemTemplate>
</asp:Repeater>
<br />
<table style="width: 600px">
<tr>
<td style="width: 100px" >当前页码为:</td>
<td >
<asp:Label ID="Label1" runat="server" Text="Label"></asp:Label></td>
<td style="width: 85px" >总页码为:</td>
<td >
<asp:Label ID="Label2" runat="server" Text="Label"></asp:Label></td>
<td align="center" >
<asp:LinkButton ID="LinkButton1" runat="server" CommandArgument="first" OnClick= "LinkButton1_Click" >首 页</asp:LinkButton>
</td>
<td align="center">
<asp:LinkButton ID="LinkButton2" runat="server" CommandArgument="prev" OnClick= "LinkButton2_Click">上一页</asp:LinkButton>
</td>
<td align="center" >
<asp:LinkButton ID="LinkButton3" runat="server" CommandArgument="next" OnClick= "LinkButton3_Click">下一页</asp:LinkButton>
</td>
<td align="center" >
<asp:LinkButton ID="LinkButton4" runat="server" CommandArgument="last" OnClick= "LinkButton4_Click">尾 页</asp:LinkButton>
</td>
</tr>
</table>
</div>
</form>
</body>
</html>
这是我做的 Repeater控件分页,大家帮我看看怎么回事,老是出错。急!
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;public partial class _Default : System.Web.UI.Page
{
SqlConnection sqlconn;
string sqlstr = "data source=localhost;database=shop;Uid=sa;Pwd=admin";
public void Page_Load(Object src, EventArgs e)
{
this.bind();
}
public void bind()
{
int curpage = Convert.ToInt32(this.Label1.Text);
Response.Write("a");
PagedDataSource ps = new PagedDataSource();
sqlconn = new SqlConnection(sqlstr);
sqlconn.Open();
string sql = "select top 5 * from book";
SqlDataAdapter MyAdapter = new SqlDataAdapter(sql, sqlstr);
DataSet ds = new DataSet();
MyAdapter.Fill(ds, "book");
ps.DataSource = ds.Tables["book"].DefaultView;
ps.AllowPaging = true; //是否可以分页
ps.PageSize = 2; //显示的数量
ps.CurrentPageIndex = curpage - 1; //取得当前页的页码
this.LinkButton1.Enabled = true;
this.LinkButton2.Enabled = true;
this.LinkButton3.Enabled = true;
this.LinkButton4.Enabled = true;
if (curpage == 1)
{
this.LinkButton1.Enabled = false;//不显示第一页按钮
this.LinkButton2.Enabled = false;//不显示上一页按钮
}
if (curpage == ps.PageCount)
{
this.LinkButton3.Enabled = false;//不显示下一页
this.LinkButton4.Enabled = false;//不显示最后一页
}
this.Label2.Text = Convert.ToString(ps.PageCount);
Repeater1.DataSource = ps;
Repeater1.DataBind();
sqlconn.Close();
}
protected void LinkButton1_Click(object sender, EventArgs e)
{
this.Label1.Text = "1";
this.bind();
}
protected void LinkButton2_Click(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
this.Label1.Text = Convert.ToString(Convert.ToInt32(this.Label1.Text) - 1);
this.bind();
}
}
protected void LinkButton3_Click(object sender, EventArgs e)
{
this.Label1.Text = Convert.ToString(Convert.ToInt32(this.Label1.Text) + 1);
this.bind();
}
protected void LinkButton4_Click(object sender, EventArgs e)
{
this.Label1.Text = this.Label2.Text;
this.bind();
}
}<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %><!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>
<form id="form1" runat="server">
<div>
<table style="width: 600px; height: 58px;">
<tr>
<td style="width: 350px; " align="center">书名</td>
<td style="width: 100px; " align="center">作者</td>
<td style="width: 150px; " align="center">出版社</td>
</tr>
</table>
<asp:Repeater ID="Repeater1" runat="server">
<ItemTemplate>
<table style="width: 600px; height: 30px;">
<tr>
<td style="width: 350px; " align="center">
<asp:Label ID="Label1" runat="server" Text='<%# DataBinder.Eval(Container.DataItem,"book_name") %>' ></asp:Label></td>
<td style="width: 100px; " align="center">
<asp:Label ID="Label2" runat="server" Text='<%# DataBinder.Eval(Container.DataItem,"writer") %>'></asp:Label></td>
<td style="width: 150px;" align="center">
<asp:Label ID="Label3" runat="server" Text='<%# DataBinder.Eval(Container.DataItem,"press") %>'></asp:Label></td>
</tr>
</table>
</ItemTemplate>
</asp:Repeater>
<br />
<table style="width: 600px">
<tr>
<td style="width: 100px" >当前页码为:</td>
<td >
<asp:Label ID="Label1" runat="server" Text="Label"></asp:Label></td>
<td style="width: 85px" >总页码为:</td>
<td >
<asp:Label ID="Label2" runat="server" Text="Label"></asp:Label></td>
<td align="center" >
<asp:LinkButton ID="LinkButton1" runat="server" CommandArgument="first" OnClick= "LinkButton1_Click" >首 页</asp:LinkButton>
</td>
<td align="center">
<asp:LinkButton ID="LinkButton2" runat="server" CommandArgument="prev" OnClick= "LinkButton2_Click">上一页</asp:LinkButton>
</td>
<td align="center" >
<asp:LinkButton ID="LinkButton3" runat="server" CommandArgument="next" OnClick= "LinkButton3_Click">下一页</asp:LinkButton>
</td>
<td align="center" >
<asp:LinkButton ID="LinkButton4" runat="server" CommandArgument="last" OnClick= "LinkButton4_Click">尾 页</asp:LinkButton>
</td>
</tr>
</table>
</div>
</form>
</body>
</html>
这是我做的 Repeater控件分页,大家帮我看看怎么回事,老是出错。急!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货