asp.net paging, 1st page shows records, but 2nd page is empty

Question

I've used asp.net gridview control. In gridview doing paging manually. But only first page shows the records. the page is completely blank. can anyone suggest what & where will I need to modify for the PageIndex Events?

Answer 1

You need to change the page index of grid and bind it in PageIndexChanged.

void GridView1_PageIndexChanging(Object sender, GridViewPageEventArgs e)
{
  GridView1.CurrentPageIndex = e.NewPageIndex;
  YourFunctionToBindGrid();
}

Answer 2

//Solved 100% work

use this code inside Page_index_Changing { GridView1.PageIndex = e.NewPageIndex; SqlCommand cmd = new SqlCommand("Select * from Requseted_movie ORDER BY [ID] DESC", con);

SqlDataAdapter DA1 = new SqlDataAdapter(cmd); DA1.Fill(DT1);

    GridView1.DataSource = DT1;
    GridView1.DataBind();

}