paging in datalist

Question

Please give us the code for showing 5 page numbers and then next,prev buttons in a standard way .we are displaying it in a datalist.

Jignesh Trivedi · Answer

hi shilpa, you can also use DataPager control (Available in .net frame work 3.5). Please refer, http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.datapager.aspx http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.datapager.pagesize.aspx http://www.codeproject.com/Articles/142326/Effective-paging-with-List-View-control-in-ASP-NET http://www.4guysfromrolla.com/articles/021308-1.aspx hope this will help you.

Satyapriya Nayak · Answer

Hi Shilpa, Try this... @ Page Language ="C#" AutoEventWireup ="true" CodeFile ="Default.aspx.cs" Inherits ="_Default" %> DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> html xmlns ="http://www.w3.org/1999/xhtml"> head runat ="server"> title > Untitled Page title > head > body > form id ="form1" runat ="server"> div > table border ="1"> asp : DataList ID ="dl1" runat ="server"> HeaderTemplate > font color ="red"> b > Employee Details b > font > HeaderTemplate > itemtemplate > tr > td > font color ="Green"> b > ID b > font > td > td > font color ="Green"> b > NAME b > font > td > td > font color ="Green"> b > SALARY b > font > td > td > font color ="Green"> b > ADDRESS b > font > td > td > font color ="Green"> b > DESIGNATION b > font > td > tr > tr > td > font color ="#ff8000"> b > # Eval( "empid" ) %> b > font > td > td > font color ="Fuchsia"> b > # Eval( "empname" ) %> b > font > td > td > font color ="#663300"> b > # Eval( "empsal" ) %> b > font > td > td > font color ="Purple"> b > # Eval( "empadd" ) %> b > font > td > td > font color ="#808040"> b > # Eval( "empdes" ) %> b > font > td > tr > itemtemplate > asp : DataList > table > table width ="100%" border ="0"> tr > td > asp : label id ="lbl1" runat ="server" BackColor ="Yellow" BorderColor ="Yellow" Font-Bold ="True" ForeColor ="#FF3300"> asp : label > td > tr > tr > td > asp : button id ="btnPrevious" runat ="server" text ="Previous" Width ="60px" onclick ="btnPrevious_Click"> asp : button > asp : button id ="btnNext" runat ="server" text ="Next" Width ="60px" onclick ="btnNext_Click"> asp : button > td > tr > table > div > form > body > html > using System; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; public partial class _Default : System.Web.UI. Page { string strConnString = ConfigurationManager .ConnectionStrings[ "ConnectionString" ].ConnectionString; string str ; SqlCommand com; SqlDataAdapter sqlda; DataSet ds; protected void Page_Load( object sender, EventArgs e) { if (!IsPostBack) { binddatalist(); } } private void binddatalist() { SqlConnection con = new SqlConnection (strConnString); con.Open(); str = "select * from employee" ; com = new SqlCommand (str, con); sqlda = new SqlDataAdapter (com); ds = new DataSet (); sqlda.Fill(ds, "employee" ); PagedDataSource Pds1 = new PagedDataSource (); Pds1.DataSource = ds.Tables[0].DefaultView; Pds1.AllowPaging = true ; Pds1.PageSize = 5; Pds1.CurrentPageIndex = CurrentPage; lbl1.Text = "Showing Page: " + (CurrentPage + 1).ToString() + " of " + Pds1.PageCount.ToString(); btnPrevious.Enabled = !Pds1.IsFirstPage; btnNext.Enabled = !Pds1.IsLastPage; dl1.DataSource = Pds1; dl1.DataBind(); con.Close(); } public int CurrentPage { get { object s1 = this .ViewState[ "CurrentPage" ]; if (s1 == null ) { return 0; } else { return Convert .ToInt32(s1); } } set { this .ViewState[ "CurrentPage" ] = value ; } } protected void btnPrevious_Click( object sender, EventArgs e) { CurrentPage -= 1; binddatalist(); } protected void btnNext_Click( object sender, EventArgs e) { CurrentPage += 1; binddatalist(); } } Thanks If this post helps you mark it as answer

paging in datalist

Answers (2)