public void dgProducts_PageChange(Object sender, DataGridPageChangedEventArgs e)
    {
        // Set CurrentPageIndex to the page the user clicked.
        dgProducts.CurrentPageIndex = e.NewPageIndex;

        FillProductGrid();
    }

 protected void dgv_total_PageIndexChanged(object source, DataGridPageChangedEventArgs e)
 {
     DataTable dt = (DataTable)ViewState["dt_Data"];
     dgv_total.CurrentPageIndex = e.NewPageIndex;
     dgv_total.DataSource = dt;
     dgv_total.DataBind();
 }

    public void dgCategories_PageChange(Object sender, DataGridPageChangedEventArgs e)
    {
        // Set CurrentPageIndex to the page the user clicked.
        dgCategories.CurrentPageIndex = e.NewPageIndex;

        FillCategoryGrid();
    }

 public void PageResultGrid(object sender, DataGridPageChangedEventArgs e)
 {
     DataSet dsGridResults;
     grdRpResults.CurrentPageIndex = e.NewPageIndex;
     dsGridResults = dsGridResults = this.Summary_Queue();
     PopulateDataGrid(dsGridResults);
 }

 public void PageResultGrid1(object sender, DataGridPageChangedEventArgs e)
 {
     DataSet dsGridResults;
     grdsubmitted.CurrentPageIndex = e.NewPageIndex;
     dsGridResults = dsGridResults = this.Summary_Queue("3");
     PopulateDataGrid(dsGridResults,grdsubmitted);
 }

 protected void DataGrid1_PageIndexChanged(object source, DataGridPageChangedEventArgs e)
 {
     string sql;
     sql = "select * from zuoyeshangjiao where shangjiaoren ='" + Session["username"].ToString().Trim() + "' order by id desc";
     getdata(sql);
     DataGrid1.CurrentPageIndex = e.NewPageIndex;
     DataGrid1.DataBind();
 }

 public void PageResultGrid1(object sender, DataGridPageChangedEventArgs e)
 {
     DataSet dsGridResults;
     grdRpResults.CurrentPageIndex = e.NewPageIndex;
     Whitfieldcore wUser = new Whitfieldcore();
     dsGridResults = wUser.GetAllSubMaterials(ddlMatType.SelectedItem.Value, "Grid");
     this.PopulateDataGrid(dsGridResults);
 }

 public void PageResultGridNotes(object sender, DataGridPageChangedEventArgs e)
 {
     Whitfieldcore wc = new Whitfieldcore();
     DataSet dsGridResults;
     grdSchedule.CurrentPageIndex = e.NewPageIndex;
     dsGridResults = wc.GetCummululativeProjectSchedule();
     this.PopulateDataGrid(dsGridResults, grdSchedule);
 }

 protected void gv1_PageIndexChanged(object source, DataGridPageChangedEventArgs e)
 {
     SetData();
     gv1.DataSource = finalCollection;
     gv1.CurrentPageIndex = e.NewPageIndex;
     gv1.DataBind();
     SetIndexingLabel(true, e.NewPageIndex);
 }

 protected void DataGrid1_PageIndexChanged(object source, DataGridPageChangedEventArgs e)
 {
     string sql;
     sql = "select * from jiaoshikaike order by id desc";
     getdata(sql);
     DataGrid1.CurrentPageIndex = e.NewPageIndex;
     DataGrid1.DataBind();
 }

 protected void DataGrid1_PageIndexChanged(object source, DataGridPageChangedEventArgs e)
 {
     string sql;
     sql = "select * from allgonggao where leibie='" + lbtxt + "' order by id desc";
     getdata(sql);
     DataGrid1.CurrentPageIndex = e.NewPageIndex;
     DataGrid1.DataBind();
 }

 public void PageResultGridNotes(object sender, DataGridPageChangedEventArgs e)
 {
     Whitfieldcore wc = new Whitfieldcore();
     DataSet dsGridResults;
     grdSchedule.CurrentPageIndex = e.NewPageIndex;
     dsGridResults = wc.GetCummululativeProjectSchedule();
     this.PopulateDataGrid(dsGridResults, grdSchedule,ddlYear.SelectedItem.Value, ddlMonth.SelectedItem.Value + "(" + ddlYear.SelectedItem.Value + ")");
 }

 protected void DataGrid1_PageIndexChanged(object source, DataGridPageChangedEventArgs e)
 {
     string sql;
     sql = "select * from zuoyefabu where faburen in (select kaikejiaoshi from xuankejilu where xuankeren='" + Session["username"].ToString().Trim() + "') order by id desc";
     getdata(sql);
     DataGrid1.CurrentPageIndex = e.NewPageIndex;
     DataGrid1.DataBind();
 }

    public void dgCustomers_PageChange(Object sender, DataGridPageChangedEventArgs e)
    {
        // Set CurrentPageIndex to the page the user clicked.
        dgCustomers.CurrentPageIndex = e.NewPageIndex;

        // Rebind the data.
        FillCustomerGrid();
        //dgCustomers.DataBind();
    }

 protected void AddedCategories_PageIndexChanged(object sender, DataGridPageChangedEventArgs e)
 {
     if (sender != null)
     {
         AddedCategoriesTable.CurrentPageIndex = e.NewPageIndex;
         AddedCategoriesTable.DataSource = Session["categories"];
         AddedCategoriesTable.DataBind();
     }
 }

 protected void project_list_PageIndexChanged(object sender, DataGridPageChangedEventArgs e)
 {
     if (sender != null)
     {
         project_list.CurrentPageIndex = e.NewPageIndex;
         project_list.DataSource = Session["projects"];
         project_list.DataBind();
     }
 }

 protected void dgv_BillDetail_PageIndexChanged(object source, DataGridPageChangedEventArgs e)
 {
     try
     {
         DataTable dt = (DataTable)ViewState["dt_Statement_Query_QH_Details"];
         dgv_BillDetail.CurrentPageIndex = e.NewPageIndex;
         dgv_BillDetail.DataSource = dt;
         dgv_BillDetail.DataBind();
     }
     catch { }
 }

 protected void dgv_Transaction_NQH_PageIndexChanged(object source, DataGridPageChangedEventArgs e)
 {
     try
     {
         DataTable dt = (DataTable)ViewState["dt_dgv_Transaction_NQH"];
         dgv_Transaction_NQH.CurrentPageIndex = e.NewPageIndex;
         dgv_Transaction_NQH.DataSource = dt;
         dgv_Transaction_NQH.DataBind();
     }
     catch { }
 }

 protected void BillDetail_PageIndexChanged(object source, DataGridPageChangedEventArgs e)
 {
     try
     {
         DataTable dt = (DataTable)ViewState["dtStatementquerytxn"];
         BillDetail.CurrentPageIndex = e.NewPageIndex;
         BillDetail.DataSource = dt;
         BillDetail.DataBind();
     }
     catch { }
 }

 protected void billedTransaction_PageIndexChanged(object source, DataGridPageChangedEventArgs e)
 {
     try
     {
         DataTable dt = (DataTable)ViewState["dtBill"];
         billedTransaction.CurrentPageIndex = e.NewPageIndex;
         billedTransaction.DataSource = dt;
         billedTransaction.DataBind();
     }
     catch
     { }
 }