GridView Paging

fififlowertot

Hi, I have a grid which is bound to data coming from a service at runtime. The issue is every time i select next page number the page goes blank. My code is as follows: for grid in aspx

        </div>

the codebehind(.cs) is typically is as follows:

on pageload:

grid1.Enabled = true;
DataTable dt = new DataTable();
dt.Columns.Add("Name");
dt.Columns.Add("ID");
dt.Rows.Add("Jack", 1);
dt.Rows.Add("Jill", 2);
dt.Rows.Add("Jack", 1);
dt.Rows.Add("Jill", 2);
dt.Rows.Add("Jack", 1);
dt.Rows.Add("Jill", 2);
dt.Rows.Add("Jack", 1);
dt.Rows.Add("Jill", 2);
dt.Rows.Add("Jack", 1);
dt.Rows.Add("Jill", 2);
dt.Rows.Add("Jack", 1);
dt.Rows.Add("Jill", 2);
dt.Rows.Add("Jack", 1);
dt.Rows.Add("Jill", 2);
dt.Rows.Add("Jack", 1);
dt.Rows.Add("Jill", 2);
grid1.DataSource = dt;
grid1.DataBind();

protected void grid1_PageIndexChanged(Object sender, GridViewPageEventArgs e)
{

    grid1.PageIndex = e.NewPageIndex;
    grid1.DataBind();
}

what am i missing here

Ravi Sant

I think you need to include your Page_Load code inside If( ! PostBack ) { } block. Please try this.

♫ 99 little bugs in the code, 99 bugs in the code We fix a bug, compile it again 101 little bugs in the code ♫

fififlowertot

yes my code is inside if (!IsPostBack) block.. but evrytime i click say page 2 the screen goes blank.

Legor

I can't reproduce this behaviour. When paging through the Grid the screen doesn't go blank. Im using VS 2010. Maybe it has something to do with the data source you've bound to the control?

fififlowertot

my datasource is a list of objects returned from the service. Since I need to format it before displaying I convert it into a datatable and this datatable is datasource to the grid. I have stepped thru and found that datatable has populated fine with all the values. even the page comes up fine with all the data and 123 page links down. it's when i click page 2/3 link in pager that it goes blank. am using vs 2008 .net 3.5

vanikanc

You should probably separate all the three subroutines. Have the !(PagePostback), datagrid itself, and the Grid1_PageIndexChanging all separate and not in one sub.

fififlowertot

my page load checks if it's not postback it calls the gridview load which does what i've posted and i have seperate event handler.

vanikanc

I had the same issue. I had to literally re-bind the entire datagrid for it to work. It worked for me, and was working under time cruch, I stuck with it.

fififlowertot

what do u mean by rebind, rewrite the code?

Sneha Bisht

copy this aspx.cs page using System; using System.Data; using System.Configuration; using System.Collections; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; public partial class test : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { BIndgrid(); } } void BIndgrid() { grid1.Enabled = true; DataTable dt = new DataTable(); dt.Columns.Add("Name"); dt.Columns.Add("ID"); dt.Rows.Add("Jack", 1); dt.Rows.Add("Jill", 2); dt.Rows.Add("Jack", 1); dt.Rows.Add("Jill", 2); dt.Rows.Add("Jack", 1); dt.Rows.Add("Jill", 2); dt.Rows.Add("Jack", 1); dt.Rows.Add("Jill", 2); dt.Rows.Add("Jack", 1); dt.Rows.Add("Jill", 2); dt.Rows.Add("Jack", 1); dt.Rows.Add("Jill", 2); dt.Rows.Add("Jack", 1); dt.Rows.Add("Jill", 2); dt.Rows.Add("Jack", 1); dt.Rows.Add("Jill", 2); grid1.DataSource = dt; grid1.DataBind(); } protected void grid1_PageIndexChanged(Object sender, GridViewPageEventArgs e) { grid1.PageIndex = e.NewPageIndex; grid1.DataBind(); BIndgrid(); } }

fififlowertot

Super. Thanks Sneha Bisht

Anky2011

Hi , Your Page_Load checks if it is not a postback right ? This means your code sets the DataSource property of your grid ONLY once and that is when the page loads for the first time. Please write the code "grid.DataSource = dataTable;" just before the code "grid.DataBind()" and let me know if it works. Always make it a habit to set the DataSource of a grid just before calling the DataBind() method on the grid. E.g. I would always code method like "BindPersonsData()" in my application which would be like - private void BindPersonsData() { grdPersons.DataSource = GetPersons(); grdPersons.DataBind(); } private DataTable GetPersons() { DataTable dt = new DataTable(); //logic to get data return dt; }

------------- Ankur - The Tech Anky Think Simple, Code Simple, Do Big