hI,Friends i am want to add pages to data list iam write code like below but it is not working properly please help me...
my code is :
protected void Page_Load(object sender, EventArgs e) {
ViewState["currentPage"]=0;
if (!Page.IsPostBack)
{
}
databinddatalist();
}
private void Binddatalistgal() {
string constr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; SqlDataAdapter dadapter = new SqlDataAdapter("SELECT Album2.AlbumID, Album2.DefaultPhotID, Album2.AlbumName,Album2.AlbumDescription, PhotAlbum.Photo FROM Album2 INNER JOIN PhotAlbum ON Album2.DefaultPhotID = PhotAlbum.PhotoID", constr);
DataSet dset = new DataSet();
adsource = new PagedDataSource();
dadapter.Fill(dset);
adsource.DataSource = dset.Tables[0].DefaultView;
adsource.PageSize = 2;
adsource.AllowPaging = true;
adsource.CurrentPageIndex = Convert.ToInt32(ViewState["currentPage"]);
dl_imgalbums.DataSource = adsource;
dl_imgalbums.DataBind();
lbnnext.Enabled = !adsource.IsLastPage;
lbnprevious.Enabled = !adsource.IsFirstPage;
}
protected void lbnprevious_Click(object sender, EventArgs e)
{
int currentPage = Convert.ToInt32(ViewState["currentPage"]);
currentPage -= 1;
ViewState["currentPage"] = currentPage;
Binddatalistgal();
}
protected void lbnnext_Click(object sender, EventArgs e)
{
int currentPage = Convert.ToInt32(ViewState["currentPage"]);
currentPage += 1;
ViewState["currentPage"] = currentPage;
Binddatalistgal();
}
when i am click in next link it will shows like
"This webpage is not available"so please help me.............
mary jean ligasPosted Dec 23, 2015, 2:36 AM
Hi I found some articles below:
http://www.aspsnippets.com/Articles/Implement-Paging-in-DataList-control-in-ASPNet.aspx
http://www.asp.net/web-forms/overview/data-access/paging-and-sorting-with-the-datalist-and-repeater/paging-report-data-in-a-datalist-or-repeater-control-cs
eswar raoPosted Dec 23, 2015, 2:32 AM
mary jean ligasPosted Dec 23, 2015, 2:17 AM