title: Databind() in GridView VERY slow!! VB.NET
body: <p>I´m facing a terrible problem in my code. When I execute DataBind method, the page loads and loads and after almost 5 minutes the GridView is filled. It´s not a SQL query problem!</p>
  
  <p>I tested with Visual Studio debuger and the code stops on DataBind()</p>
  
  <blockquote>
  <pre><code>Protected Sub btnShow_Click(ByVal sender As Object, ByVal e As System.EventArgs)
  
          /* This is not the correct code but at the end, the result will be same as below */
  
          Dim feedback As String = "positive"
          Dim date As String = "2013"
  
          bindDataShowDetails(feedback, date) // &lt;----- I call this method ( below )
  
    End Sub
  </code></pre>
  </blockquote>
  
  <pre><code>Protected Sub bindDataShowDetails(ByVal feedback As String, ByVal Data As String())
  
          feedbackGlobal = feedback
  
          Dim strSql As String = ""
  
          strSql = " select "
          strSql += " feedback, zendesk_ticket_id,feedback_text as Comment, date_ins as Ticket_date, date_feedback as Feedback_date, comment_review, review_status "
          strSql += "  from feedbacks_support "
          strSql += " where "
          strSql += " feedback = '" &amp; feedback &amp; "'" // &lt;---- 'positive'
          strSql += " and YEAR(date_feedback) = " &amp; Date // &lt;---- '2013'
  
  
          Dim myreader As SqlDataReader = admin2.ExecReader(strSql) // &lt;--- Class 'admin2' calls the method (ExecReader) thats executes the SQL query and return the result.
  
          GridView1.DataSource = myreader
          GridView1.DataBind() &lt;----------- Problem is here!!!
  
          Me.ModalPopupExtender1.Show()
  
  
      End Sub
  </code></pre>
  
  <p>I ran the SQL query directy in SQL Server and it runs fine!</p>
  
  <p>I really don´t know what is wrong! 
  Thanks very much for your support!</p>