title: Display Results of SQL Query using VB/ASP
body: <p>This application I'm building imports data into a database and runs some magic on it. I then want to display the results of a separate query on my page. It's kinda sorta not really working now.</p>
  
  <p>The app call:</p>
  
  
  
  <pre class="lang-vb prettyprint-override"><code>Dim leftovers As IDataReader
  
  leftovers = GetImportDetails()
  
  Response.Write("&lt;B&gt;Records that were not updated:&lt;/B&gt;&lt;BR&gt;")
  Response.Write(leftovers)
  Response.Write("&lt;BR&gt;&lt;B&gt;Processing Complete.&lt;/B&gt;&lt;BR&gt;&lt;BR&gt;")
  </code></pre>
  
  <p>And the function:</p>
  
  <pre class="lang-vb prettyprint-override"><code>Function GetImportDetails() As IDataReader
      Dim strSQL As String, DAL As New DAL.DataAccess
      Dim dr As IDataReader
  
      'Get a list of records that weren't updated
      strSQL = "SELECT SalesRep, IDNumber, Name, EffDate, Product, CancDate, Reason " &amp; _
              " FROM tblCommCancel"
      dr = DAL.ExecDataReader(strSQL, CommandType.Text)
      GetImportDetails = dr
  
      dr = Nothing
      DAL = Nothing
  End Function
  </code></pre>
  
  <p>Right now, my output looks as follows:</p>
  
  <pre class="lang-vb prettyprint-override"><code>Records that were not updated:
  System.Data.SqlClient.SqlDataReader
  Processing Complete.
  </code></pre>
  
  <p>What am I missing here?</p>