namespace PagininDataList
{
public partial class DisplayTestimonials : System.Web.UI.Page
{
SqlDataAdapter dadapter;
DataSet dset;
PagedDataSource adsource;
string connstring = "Data Source = .; Initial Catalog = medicalvoyager; Integrated Security = true";
int pos;
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ViewState["vs"] = 0;
}
pos = (int)this.ViewState["vs"];
databind();
}
public void databind()
{
dadapter = new SqlDataAdapter("select * from testimonial", connstring);
dset = new DataSet();
adsource = new PagedDataSource();
dadapter.Fill(dset);
adsource.DataSource = dset.Tables[0].DefaultView;
adsource.PageSize = 3;
adsource.AllowPaging = true;
adsource.CurrentPageIndex = pos;
btnfirst.Enabled = !adsource.IsFirstPage;
btnprevious.Enabled = !adsource.IsFirstPage;
btnlast.Enabled = !adsource.IsLastPage;
btnnext.Enabled = !adsource.IsLastPage;
DataList1.DataSource = adsource;
DataList1.DataBind();
}
protected void btnfirst_Click(object sender, EventArgs e)
{
pos = 0;
databind();
}
protected void btnprevious_Click(object sender, EventArgs e)
{
pos = (int)this.ViewState["vs"];
pos -= 1;
this.ViewState["vs"] = pos;
databind();
}
protected void btnnext_Click(object sender, EventArgs e)
{
pos = (int)this.ViewState["vs"];
pos += 1;
this.ViewState["vs"] = pos;
databind();
}
protected void btnlast_Click(object sender, EventArgs e)
{
pos = adsource.PageCount - 1;
databind();
}
}
}
<pre lang="c#">