title: Performance Issues loading large data set into c# GridView
body: <p>Ok,</p>
  
  <p>been testing relatively small data sets into my GridView, and all has worked fine. However, i've now moved into proper UAT and have tried to load 17,000 records into my Grid, which has basically brought my web app to a grinding halt.</p>
  
  <p>Basically, a user logs in, and upon validation all the data grids are loaded, one of which contains 17k records. Until everything loads the end user is left handing on the logon page. So i need to fix it.</p>
  
  <p>The code for the Grids is:</p>
  
  <pre><code>DataTable dtValueDateCurrency = null;               
  SqlConnection conn = new SqlConnection(WebConfigurationManager.ConnectionStrings["Reporting"].ConnectionString);
  using (conn)
  {
      conn.Open();
      //Load all other grid data
      using (SqlDataAdapter sqlAdapter = new SqlDataAdapter(TSQL1, conn))
      {
          dtValueDateSummary = new DataTable();
          sqlAdapter.Fill(dtValueDateSummary);
          grdValueDateSummary.DataSource = dtValueDateSummary;
          grdValueDateSummary.DataBind();
      }
   }
  </code></pre>
  
  <p>Is there a way to increase the load times? Pagination isn't an option, as i'm taking care of this with JQuery.</p>