title: Accessing sql server temporary table from asp.net
body: <p>What I am missing to get data from temporary table. This is showing error like Invalid object name #emp. Please help me
  I am using Asp.net.</p>
  
  <pre><code> Dim sqlcmd = New SqlCommand("select * into #emp from employees", conn)
   sqlcmd.ExecuteNonQuery()
  
   sqlcmd = New SqlCommand("select * from  #emp", conn)
   Dim dr As SqlDataReader = sqlcmd.ExecuteReader
  </code></pre>
  
  <p>See Above query is working fine and data is going into temporary table. but it is not selecting again through second one query.</p>
  
  <p>Thanks</p>