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();