title: ASP.NET why Gridview Paging on page 2 and the rest of it are disappear?
body: <p>I have so many list of ServerName in GridView, so I decide to add paging. The data show list result on page 1 but on page 2 and the rest of it is not display anything. I already have <code>OnPageIndexChanging="GridViewServer_PageIndexChanging"</code> in GridViewServer property. Please help! Here is c# code behind,</p>
  
  <pre><code>protected void GridViewServer_PageIndexChanging(object sender, GridViewPageEventArgs e)
      {
          GridViewServer.PageIndex = e.NewPageIndex;
          GridViewServer.DataBind();
      }
  </code></pre>
  
  <p>A GridView binding function codes,</p>
  
  <pre><code>public void BindGridView()
      {
          SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Database_Shared_NotebookConnectionString"].ConnectionString);
  
          conn.Open();
  
          string sqlquery = ("SELECT * FROM tblServer");
  
          SqlCommand command = new SqlCommand(sqlquery, conn);
  
          SqlDataAdapter adp = new SqlDataAdapter(command);
  
          DataSet ds = new DataSet();
  
          adp.Fill(ds);
  
          GridViewServer.DataSource = ds.Tables[0];
  
          GridViewServer.DataBind();
      }
  </code></pre>