if(!this.IsPostBack)
{
this.labCurPage.Text = "1"; //当前页
this.DBBinder();
this.DDList();
}
public void DBBinder()
{
int curPage = Convert.ToInt32(this.labCurPage.Text);
SqlConnection conn = DB.createConn();
SqlDataAdapter sda = new SqlDataAdapter();
sda.SelectCommand = new SqlCommand("select * from GuestBook order by userID Desc",conn);
DataSet ds = new DataSet();
sda.Fill(ds,"GuestBook");
System.Web.UI.WebControls.PagedDataSource ps = new PagedDataSource();
ps.AllowPaging = true; //是否支持分页
ps.PageSize = 5;
ps.DataSource = ds.Tables["GuestBook"].DefaultView;
ps.CurrentPageIndex = curPage - 1; //当前索引
this.countpage = ps.PageCount; //全局变量,取得总页数
this.lab总页数.Text = Convert.ToString(ps.PageCount);
this.lab总记录.Text = Convert.ToString(ps.DataSourceCount);
this.btn首页.Enabled = true;
this.btn上一页.Enabled = true;
this.btn下一页 = true;
this.btn尾页.Enabled = true;
if(curPage == 1)
{
this.btn首页.Enabled = false;
this.btn上一页.Enabled = false;
}
if(curPage == ps.PageCount)
{
this.btn尾页.Enabled = false;
this.btn下一页.Enabled = false;
}
this.DataList1.DataSource = ps; //数据源等于自己定义
this.DataList1.DataBind();
this.ddList.SelectedIndex = Convert.ToInt32(this.labCurPage.Text) - 1; //DropDownList控件显示当然页数
conn.Close();
}
//DropDownList循环显示页数
public void DDList()
{
for(int i=1; i<=this.countpage; i++) //conutpage为全局变量,取得总页数
{
this.ddList.Items.Add(new ListItem("第"+i+"页",(i-1).ToString()));
}
}
private void ddlist_SelectedIndexChanged(object sender, System.EventArgs e)
{
this.labCurPage.Text = Convert.ToString(int.Parse(this.ddList.SelectedValue) + 1);
this.DBBinder();
}
{
this.labCurPage.Text = "1"; //当前页
this.DBBinder();
this.DDList();
}
public void DBBinder()
{
int curPage = Convert.ToInt32(this.labCurPage.Text);
SqlConnection conn = DB.createConn();
SqlDataAdapter sda = new SqlDataAdapter();
sda.SelectCommand = new SqlCommand("select * from GuestBook order by userID Desc",conn);
DataSet ds = new DataSet();
sda.Fill(ds,"GuestBook");
System.Web.UI.WebControls.PagedDataSource ps = new PagedDataSource();
ps.AllowPaging = true; //是否支持分页
ps.PageSize = 5;
ps.DataSource = ds.Tables["GuestBook"].DefaultView;
ps.CurrentPageIndex = curPage - 1; //当前索引
this.countpage = ps.PageCount; //全局变量,取得总页数
this.lab总页数.Text = Convert.ToString(ps.PageCount);
this.lab总记录.Text = Convert.ToString(ps.DataSourceCount);
this.btn首页.Enabled = true;
this.btn上一页.Enabled = true;
this.btn下一页 = true;
this.btn尾页.Enabled = true;
if(curPage == 1)
{
this.btn首页.Enabled = false;
this.btn上一页.Enabled = false;
}
if(curPage == ps.PageCount)
{
this.btn尾页.Enabled = false;
this.btn下一页.Enabled = false;
}
this.DataList1.DataSource = ps; //数据源等于自己定义
this.DataList1.DataBind();
this.ddList.SelectedIndex = Convert.ToInt32(this.labCurPage.Text) - 1; //DropDownList控件显示当然页数
conn.Close();
}
//DropDownList循环显示页数
public void DDList()
{
for(int i=1; i<=this.countpage; i++) //conutpage为全局变量,取得总页数
{
this.ddList.Items.Add(new ListItem("第"+i+"页",(i-1).ToString()));
}
}
private void ddlist_SelectedIndexChanged(object sender, System.EventArgs e)
{
this.labCurPage.Text = Convert.ToString(int.Parse(this.ddList.SelectedValue) + 1);
this.DBBinder();
}