自定义分页

private  OleDbConnection con  =   new  OleDbConnection();

private   void  Page_Load( object  sender, System.EventArgs e)
{
        OpenDataBase();
        BindDataGrid();
}

private   void  OpenDataBase()
{
    con.ConnectionString  =   " Provider = SqlOleDb; WorkStation ID = 127.0.0.1; Initial Catalog = Northwind; User ID = sa; PassWord = ; Connect TimeOut = 30; Packet Size = 1024; Persist Security Info = false " ;
    con.Open();
}

public   void  BindDataGrid()
{
    OleDbConnection myConnection  =  con;
    DataSet ds  =   new  DataSet();
    OleDbDataAdapter adapter  =   new  OleDbDataAdapter( " Select LastName, FirstName, Address From Employees " , myConnection);
    adapter.Fill(ds,  " Document " );
    dgdNorthwind.DataSource  =  ds.Tables[ " Document " ].DefaultView;
    dgdNorthwind.DataBind();
    ShowState();
}

private   void  ShowState()
{
    lblPageCount.Text  =   " 总共  "   +  dgdNorthwind.PageCount  +   "  页 " ;
    lblCurrentPageIndex.Text  =   " 第  "   +  (dgdNorthwind.CurrentPageIndex  +   1 ).ToString()  +   "  页 " ;
}

private   void  dgdNorthwind_PageIndexChanged( object  source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
{
    dgdNorthwind.CurrentPageIndex  =  e.NewPageIndex;
    BindDataGrid();
}

private   void  ClickButton( object  sender, EventArgs e)
{
     string  arg  =  ((LinkButton)sender).CommandArgument.ToString();

     switch (arg)
    {
         case   " Next " :
             if  (dgdNorthwind.CurrentPageIndex  <  (dgdNorthwind.PageCount  -   1 ))
            {
                dgdNorthwind.CurrentPageIndex  +=   1 ;
            }
             break ;
         case   " Prev " :
             if  (dgdNorthwind.CurrentPageIndex  >   0 )
            {
                dgdNorthwind.CurrentPageIndex  -=   1 ;
            }
             break ;
         case   " Last " :
                dgdNorthwind.CurrentPageIndex  =  dgdNorthwind.PageCount  -   1 ;
             break ;
         default :
            dgdNorthwind.CurrentPageIndex  =   0 ;
             break ;
    }

    BindDataGrid();
}