SharePoint - Datagrid returning blank grid form page 2

Asked By Chester Thomas on 24-Jun-11 05:40 AM
Earn up to 10 extra points for answering this tough question.
I have the code below, I can view te first page of the grid but when I g to page 2 and more I get blank grids returned. Can you guys pick up anything wrong?

.....................................

queryproc.RowLimit = 100;
        SPListItemCollection procitems = ProcessedList.GetItems(queryproc);
        DataTable ProcData = procitems.GetDataTable();
        FinanceGrid.PageSize = 30;
        FinanceGrid.AllowPaging = true;
        FinanceGrid.PageIndexChanging += new GridViewPageEventHandler(FinanceGrid_PageIndexChanging);
        //FinanceGrid.AllowSorting = true;
        FinanceGrid.DataSource = ProcData;
        this.Controls.Add(FinanceGrid);
        FinanceGrid.PagerTemplate = null;
        FinanceGrid.DataBind();
  
..........................
  
//Eventhandler
  
    void FinanceGrid_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
      FinanceGrid.PageIndex = e.NewPageIndex;
      FinanceGrid.DataBind();


Venkat K replied to Chester Thomas on 25-Jun-11 10:11 PM
Really like to see your query "queryproc"
Chester Thomas replied to Venkat K on 27-Jun-11 02:31 AM
Hi, my query is just filtering for a certain status which is approved. Even if I take it out I get the same problem. I have taken out postbacjk and now it shows the same data for all grids.