Pagination dans le contrôle DataList

Question

À la différence du contrôle GridView, le contrôle DataList n'a pas de prise en charge de pagination automatique. Pour prendre en charge la pagination, vous devez ajouter du code, comme illustré dans l'exemple suivant :

 

int PageSize, RecordCount, PageCount, CurrentPage;
SqlConnection MyConn;
public int IndexOfPage
{
    get { return (int)ViewState["_IndexOfPage"]; }
    set { ViewState["_IndexOfPage "] = value; }
}
public int CountOfPage
{
    get { return (int)ViewState["_CountOfPage"]; }
    set { ViewState["_CountOfPage"] = value; }
}
public void Page_Load(Object src, EventArgs e)
{
    PageSize = 3;
    string MyConnString = 
     @"Server=(local)\SQLEXPRESS;Integrated Security=SSPI;Database=test;Persist Security Info=True";
    MyConn = new SqlConnection(MyConnString);
    MyConn.Open();
    if (!Page.IsPostBack)
    {
        ListBind();
        CurrentPage = 0;
        IndexOfPage = 0;
        RecordCount = CalculateRecord();
        lblRecordCount.Text = RecordCount.ToString();
        PageCount = RecordCount / PageSize;
        lblPageCount.Text = PageCount.ToString();
        CountOfPage = PageCount;
    }
}  
public int CalculateRecord()
{
    int intCount;
    string strCount = "select count(*) as co from student";
    SqlCommand MyComm = new SqlCommand(strCount, MyConn);
    SqlDataReader dr = MyComm.ExecuteReader();
    if (dr.Read())
    {
        intCount = Int32.Parse(dr["co"].ToString());
    }
    else
    {
        intCount = 0;
    }
    dr.Close();
    return intCount;
}
ICollection CreateSource()
{
    int StartIndex;
    StartIndex = CurrentPage * PageSize;
    string strSel = "select * from student";
    DataSet ds = new DataSet();
    SqlDataAdapter MyAdapter = new SqlDataAdapter(strSel, MyConn);
    MyAdapter.Fill(ds, StartIndex, PageSize, "Score");
    return ds.Tables["Score"].DefaultView;
}
public void ListBind()
{
    DataList1.DataSource = CreateSource();
    DataList1.DataBind();
    lbnNextPage.Enabled = true;
    lbnPrevPage.Enabled = true;
    if (CurrentPage == (PageCount - 1)) lbnNextPage.Enabled = false;
    if (CurrentPage == 0) lbnPrevPage.Enabled = false;
    lblCurrentPage.Text = (CurrentPage + 1).ToString();
}
public void Page_OnClick(Object sender, CommandEventArgs e)
{
    CurrentPage = (int)IndexOfPage;
    PageCount = (int)CountOfPage;
    string cmd = e.CommandName;
    switch (cmd)
    {
        case "next":
            if (CurrentPage < (PageCount - 1)) CurrentPage++;
            break;
        case "prev":
            if (CurrentPage > 0) CurrentPage--;
            break;
    }
    IndexPage = CurrentPage;
    ListBind();
}

 

Pour plusieurs informations, visitez la page Foire aux Questions – ASP.NET

 

 

---

Appel à contribution ! http://social.msdn.microsoft.com/Forums/fr-FR/vbasicfr/thread/ff4910bf-dca4-4664-b01e-b58bd860a643