DataGrid paging not working!

[petem]

Hi,

I have a Datagrid that returns search results. It was working fine but now when you click on a paging link it returns ALL records rather than just those returned from the search.

Example:
click on search:
- searchresults.aspx shows 5 records saying '1 to 5 of 23'

click on a link to page 2 or page 3 etc and:
- searchresults.aspx shows 5 records saying '6 to 10 of 102'

The paging links are default DataGrid paging links.
The DataGrid is cached as 'dv'+ Session.SessionID,

Does anyone know what may be going wrong?

here's my PageIndexChanged code:

private void DataGrid1_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
  {
      DataGrid1.CurrentPageIndex = e.NewPageIndex;
      DataGrid1.DataSource = (DataView)Cache["dv" + Session.SessionID];
      DataGrid1.DataBind();
      SetPageStats();
   }

thanks in advance,

Pete

 

[Robby]

Are you doing the same databind routine in the Page Load event? If so place the routine in an IF block...

if (! ispostback()){
// databind here}

 

[petem]

Here's my Page_Load code:

if (!Page.IsPostBack)
GetResults();

GetResults() also has the bind code in it. is this what you mean?

Within GetResults() - after the connection string & SProc call etc:

DataView dv = new DataView(ds.Tables[0]);

Cache["dv" + Session.SessionID] = dv;
if(dv.Count == 0)
  {
     NoRecordsFoundLabel.Text = "No Jobs Found.";
     NoRecordsFoundLabel.Visible = true;
     DataGrid1.Visible = false;
  }
DataGrid1.DataSource = dv;
DataGrid1.DataBind();

Are you doing the same databind routine in the Page Load event? If so place the routine in an IF block...

if (! ispostback()){
// databind here}

I stuck a Breakpoint in the code on the Page_Load and tried clicking a paging link. Page.IsPostBack was True. Dunno if this helps,

cheers,

Pete

 

[shroomy]

first, just to be sure... you did set the pagesize of the datagrid to be something reasonable right???

second, I am mostly a VB guy but Im going to try ...

try this

ICollection DataSource()
{
     //fill your table here.....
     DataView dv = new DataView(ds.Tables[0]);
     return (ICollection)New DataView(ds.Tables[0]);
   
}


void GetResults()
{
DataGrid1.DataSource = dv;
DataGrid1.DataBind();
}



private void DataGrid1_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
  {
     DataGrid1.CurrentPageIndex = e.NewPageIndex;
     GetResults();
   }