protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
bind();
}
}
void bind()
{
int curpage = Convert.ToInt32(this.Label1.Text);
PagedDataSource ps = new PagedDataSource();
pagebind(ps);
ps.AllowPaging = true;
ps.PageSize = 5;
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 = ps.PageCount.ToString();
this.DataList1.DataSource = ps;
this.DataList1.DataBind();
}
void pagebind(PagedDataSource pd)
{
string strcon="server=.;database=pubs;uid=sa;pwd=sa";
SqlConnection cn = new SqlConnection(strcon);
SqlDataAdapter da = new SqlDataAdapter("select title_id,title,price from titles", cn);
DataSet ds = new DataSet();
da.Fill(ds, "titles");
pd.DataSource = ds.Tables["titles"].DefaultView;
}
protected void LinkButton1_Click(object sender, EventArgs e)
{
this.Label1.Text = "1";
bind();
}
protected void LinkButton2_Click(object sender, EventArgs e)
{
this.Label1.Text = (Convert.ToInt32(this.Label1.Text) - 1).ToString();
bind();
}
protected void LinkButton3_Click(object sender, EventArgs e)
{
this.Label1.Text=(Convert.ToInt32(this.Label1.Text)+1).ToString();
bind();
}
protected void LinkButton4_Click(object sender, EventArgs e)
{
this.Label1.Text = Label2.Text;
bind();
}
{
if (!IsPostBack)
{
bind();
}
}
void bind()
{
int curpage = Convert.ToInt32(this.Label1.Text);
PagedDataSource ps = new PagedDataSource();
pagebind(ps);
ps.AllowPaging = true;
ps.PageSize = 5;
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 = ps.PageCount.ToString();
this.DataList1.DataSource = ps;
this.DataList1.DataBind();
}
void pagebind(PagedDataSource pd)
{
string strcon="server=.;database=pubs;uid=sa;pwd=sa";
SqlConnection cn = new SqlConnection(strcon);
SqlDataAdapter da = new SqlDataAdapter("select title_id,title,price from titles", cn);
DataSet ds = new DataSet();
da.Fill(ds, "titles");
pd.DataSource = ds.Tables["titles"].DefaultView;
}
protected void LinkButton1_Click(object sender, EventArgs e)
{
this.Label1.Text = "1";
bind();
}
protected void LinkButton2_Click(object sender, EventArgs e)
{
this.Label1.Text = (Convert.ToInt32(this.Label1.Text) - 1).ToString();
bind();
}
protected void LinkButton3_Click(object sender, EventArgs e)
{
this.Label1.Text=(Convert.ToInt32(this.Label1.Text)+1).ToString();
bind();
}
protected void LinkButton4_Click(object sender, EventArgs e)
{
this.Label1.Text = Label2.Text;
bind();
}