paging in datalist control

Hi Satya Prakash,

Default.aspx code

<%@ Page Language="C#" AutoEventWireup="true"  CodeFile="Default.aspx.cs" Inherits="_Default" %>





   


   

   

   
    
   
     
      Employee Details
     
     
        
        
        
        
        
        
        
        
           
              
              
              
              
              
           
        
  
     
  

ID	NAME	SALARY	ADDRESS	DESIGNATION
<%#Eval("empid")%>	<%#Eval("empname")%>	<%#Eval("empsal")%>	<%#Eval("empadd")%>	<%#Eval("empdes")%>

  
     
        
     
     
      
     
  

Font-Bold="True" ForeColor="#FF3300">

onclick="btnPrevious_Click">                             onclick="btnNext_Click">

   

   

Default.aspx.vb code

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 = 3;
        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

Hi Satya Prakash,

To get more idea about paging in datalist control, visit following links

http://www.c-sharpcorner.com/UploadFile/pandeypradip/sql-paging-in-Asp-Net-using-sql-server-Asp-Net-and-C-Sharp/

This is implemented by using Repeater control but you can also use it for datalist control only by changing the control in your .aspx page.

Other links are
http://www.c-sharpcorner.com/UploadFile/718fc8/paging-in-datalist-control/
http://www.c-sharpcorner.com/uploadfile/cd3aa3/creating-custom-paging-for-datalist-control/

Hope it will help.