using System;
using System.Data;
using System.Configuration;
using System.Collections;
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 test_Default5 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
SqlConnection con = new SqlConnection();
con.ConnectionString = "server=.;database=EastHH_Product_Quote;uid=sa";
con.Open();
string sql = "select * from S_bug";
SqlDataAdapter da = new SqlDataAdapter(sql, con);
DataSet ds = new DataSet();
try
{
da.Fill(ds, "page");
PagedDataSource mypaged = new PagedDataSource();
mypaged.DataSource = ds.Tables[0].DefaultView;
mypaged.AllowPaging = true;
mypaged.PageSize = 5;
int mycurrentpage;
if (Request.QueryString["page"] != null)
{
mycurrentpage = Convert.ToInt32(Request.QueryString["page"].ToString());
}
else
{
mycurrentpage = 1;
}
mypaged.CurrentPageIndex = mycurrentpage - 1;
this.Label1.Text = "当前页为:"+mycurrentpage.ToString()+"/"+mypaged.PageCount;
if (!mypaged.IsFirstPage)
{
this.HyperLink1.NavigateUrl = Request.CurrentExecutionFilePath + "?page=" + Convert.ToString(mycurrentpage - 1);
}
if (!mypaged.IsLastPage)
{
this.HyperLink2.NavigateUrl = Request.CurrentExecutionFilePath + "?page=" + Convert.ToString(mycurrentpage + 1);
}
this.Repeater1.DataSource = mypaged;
this.Repeater1.DataBind();
}
catch
{
}
}
}
}