title: Paging in Gridview not working 2nd page data not showing data?
body: <p>my gridview</p>
  
  <pre><code>&lt;div style="margin-left: 280px"&gt;
     &lt;asp:GridView ID="exportGrdVw" runat="server" BackColor="White"  
          AllowPaging="True" PageSize="3" 
          OnPageIndexChanging="exportGrdVw_PageIndexChanging" 
          onpageindexchanged="exportGrdVw_PageIndexChanged"&gt;
     &lt;/asp:GridView&gt;
  &lt;/div&gt;
  </code></pre>
  
  <p>my code</p>
  
  <pre><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();
   }
  </code></pre>
  
  <p>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</p>