protected void Page_Load(object sender, EventArgs e)
{ if (!IsPostBack)
{
Bind();
} }
public void Bind()
{
int CurrentPage = 1;
PagedDataSource ps = new PagedDataSource();
string sqlstr = "select * from UserInfo";
SqlDataAdapter da = new SqlDataAdapter(sqlstr, sqlcon);
DataSet ds = new DataSet();
da.Fill(ds, "UserInfo");
ps.DataSource = ds.Tables["UserInfo"].DefaultView;
ps.AllowPaging = true;
ps.PageSize = 5;
ps.CurrentPageIndex = CurrentPage - 1;
lnkbtnFront.Enabled = true;
lnkbtnFirst.Enabled = true;
lnkbtnNext.Enabled = true;
lnkbtnLast.Enabled = true;
if (CurrentPage == 1)
{
lnkbtnFirst.Enabled = false;
lnkbtnFront.Enabled = false;
}
if (CurrentPage == ps.PageCount)
{
lnkbtnNext.Enabled = false;
lnkbtnLast.Enabled = false;
}
this.labCount.Text = Convert.ToString(ps.PageCount);
this.DataList1.DataSource = ps;
this.DataList1.DataKeyField = "ID";
this.DataList1.DataBind();
}
protected void lnkbtnFirst_Click(object sender, EventArgs e)
{
this.labNowPage.Text = "1";
this.Bind();
}
protected void lnkbtnFront_Click(object sender, EventArgs e)
{
this.labNowPage.Text = Convert.ToString(Convert.ToInt32(this.labNowPage.Text) - 1);
this.Bind();
}
protected void lnkbtnNext_Click(object sender, EventArgs e)
{
this.labNowPage.Text = Convert.ToString(Convert.ToInt32(this.labNowPage.Text) + 1);
this.Bind();
}
protected void lnkbtnLast_Click(object sender, EventArgs e)
{
this.labNowPage.Text = this.labCount.Text;
this.Bind();
}
{ if (!IsPostBack)
{
Bind();
} }
public void Bind()
{
int CurrentPage = 1;
PagedDataSource ps = new PagedDataSource();
string sqlstr = "select * from UserInfo";
SqlDataAdapter da = new SqlDataAdapter(sqlstr, sqlcon);
DataSet ds = new DataSet();
da.Fill(ds, "UserInfo");
ps.DataSource = ds.Tables["UserInfo"].DefaultView;
ps.AllowPaging = true;
ps.PageSize = 5;
ps.CurrentPageIndex = CurrentPage - 1;
lnkbtnFront.Enabled = true;
lnkbtnFirst.Enabled = true;
lnkbtnNext.Enabled = true;
lnkbtnLast.Enabled = true;
if (CurrentPage == 1)
{
lnkbtnFirst.Enabled = false;
lnkbtnFront.Enabled = false;
}
if (CurrentPage == ps.PageCount)
{
lnkbtnNext.Enabled = false;
lnkbtnLast.Enabled = false;
}
this.labCount.Text = Convert.ToString(ps.PageCount);
this.DataList1.DataSource = ps;
this.DataList1.DataKeyField = "ID";
this.DataList1.DataBind();
}
protected void lnkbtnFirst_Click(object sender, EventArgs e)
{
this.labNowPage.Text = "1";
this.Bind();
}
protected void lnkbtnFront_Click(object sender, EventArgs e)
{
this.labNowPage.Text = Convert.ToString(Convert.ToInt32(this.labNowPage.Text) - 1);
this.Bind();
}
protected void lnkbtnNext_Click(object sender, EventArgs e)
{
this.labNowPage.Text = Convert.ToString(Convert.ToInt32(this.labNowPage.Text) + 1);
this.Bind();
}
protected void lnkbtnLast_Click(object sender, EventArgs e)
{
this.labNowPage.Text = this.labCount.Text;
this.Bind();
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货