A convenient DataGrid Pager Control

• Download source files - 12.8 Kb
• Download demo project - 19.8 Kb

Introduction

Last time, I submitted a web control to configure the data connection in web.config for a web site, it was easy and convenient. This time let's us go for a most convenient DataGrid Pager control. The steps involved are as follows:

1. Drag and drop a Pager and a PagerExt web control into a web page.
2. Set the property ControlID to DataGrid's ID or set it in the code as shown below:

   

   override protected void OnInit(EventArgs e)
   {
       InitializeComponent();
       base.OnInit(e);
   
       this.Pager1.ControlID = this.DataGrid1.ID;
       this.PagerExt1.ControlID = this.DataGrid1.ID;
   }

3. Write a data bind function:

   private void BindGrid()
   {
       try
       {
           this.DataGrid1.DataSource = 
                       obj.GetDataSet(this.TextBox1.Text);
           this.DataGrid1.DataBind();
           
           // this is important for the show current 
           // page number correctly.
           this.PagerExt1.Refresh(); 
       }
       catch
       {
           this.Page.RegisterStartupScript
           ("","<script>alert('Please check the sql " + 
                          "cmd or wbe.config');</script>");
       }
   }

4. Events coding:

   private void Pager1_PagerClick(object sender, 
                                    System.EventArgs e)
   {
       this.BindGrid();
   }
   private void PagerExt1_PageGoClick(object sender, 
                                    System.EventArgs e)
   {
       this.BindGrid();
   }

Testing your DataGrid pager control

How to do

private void Pager_Click(object sender, EventArgs e)
{
    if (this.Page.FindControl(this.ControlID) == null)
        return;

    String arg = ((LinkButton)sender).CommandArgument;

    try
    {
      switch(arg)
      {
        case "First":
           ((System.Web.UI.WebControls.DataGrid)this.
                Page.FindControl(this.ControlID)).CurrentPageIndex = 0;
            this.OnPagerCmd(e);
            break;
        case "Prev":
            if (((System.Web.UI.WebControls.DataGrid)this.
                      Page.FindControl(this.ControlID)).CurrentPageIndex > 0)
               ((System.Web.UI.WebControls.DataGrid)this.Page.
                               FindControl(this.ControlID)).CurrentPageIndex --;
            this.OnPagerCmd(e);
            break;
        case "Next":
            if (((System.Web.UI.WebControls.DataGrid)this.
                         Page.FindControl(this.ControlID)).CurrentPageIndex < 
                (((System.Web.UI.WebControls.DataGrid)this.
                               Page.FindControl(this.ControlID)).PageCount - 1))
                ((System.Web.UI.WebControls.DataGrid)this.
                          Page.FindControl(this.ControlID)).CurrentPageIndex ++;
            this.OnPagerCmd(e);
            break;
        case "Last":
            ((System.Web.UI.WebControls.DataGrid)this.
               Page.FindControl(this.ControlID)).CurrentPageIndex = 
                              ((System.Web.UI.WebControls.DataGrid)this.
                                Page.FindControl(this.ControlID)).PageCount - 1;
            this.OnPagerCmd(e);
            break;
      }
    }
    catch
    {
        return;
    }
}

This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here