Paging in Gridview not working 2nd page data not showing data?

asp.net, gridview, paging

Solution

Use like below

SqlConnection con = new SqlConnection("server=acer-Pc\\Sql;database=MYDB;trusted_connection=yes");
//DataSet ds = new DataSet();
DataTable table = new DataTable();    
protected void Page_Load(object sender, EventArgs e)
{        
   if (!IsPostBack)
   {              
       BindEmployee();
   }
}
public void BindEmployee()
{
    SqlDataAdapter da = new SqlDataAdapter("select customername,contactno,address from employee ", con);
    da.Fill(table);
    exportGrdVw.DataSource = table;
    exportGrdVw.DataBind();
}
protected void exportGrdVw_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
    exportGrdVw.PageIndex = e.NewPageIndex;
    BindEmployee();
}

Problem

my gridview ``` <div style="margin-left: 280px"> <asp:GridView ID="exportGrdVw" runat="server" BackColor="White" AllowPaging="True" PageSize="3" OnPageIndexChanging="exportGrdVw_PageIndexChanging" onpageindexchanged="exportGrdVw_PageIndexChanged"> </asp:GridView> </div> ``` my code ``` SqlConnection con = new SqlConnection("server=acer-Pc\\Sql;database=MYDB;trusted_connection=yes"); //DataSet ds = new DataSet(); DataTable table = new DataTable(); protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { SqlDataAdapter da = new SqlDataAdapter("select customername,contactno,address from employee ", con); da.Fill(table); BindEmployee(); } } public void BindEmployee() { exportGrdVw.DataSource = table; exportGrdVw.DataBind(); } protected void exportGrdVw_PageIndexChanging(object sender, GridViewPageEventArgs e) { exportGrdVw.PageIndex = e.NewPageIndex; BindEmployee(); } ``` the problem is gridview is displaying but when i click page 2. 2nd page data is not showing (blank). pls help me to solve this problem. see that the code is correct or not

Original source