title: ASP.NET & SQL Server : can #temp-table be used by an ASP.NET webforms application?
body: <p>In our  ASP.NET 4.6 webforms application using SQL Server, we want a page to use a <code>#temptable</code>, but we cannot get it to work. <code>Page1</code> creates the <code>#temptable</code> in SQL Server, and then launches <code>Page2</code> that wants to put the <code>#temptable</code> into a GridView to be edited within the grid.</p>
  
  <p>It appears that the scope of the <code>#temptable</code> does not extend beyond <code>Page1</code> on the server when the <code>Page2</code> is loaded and becomes visible to the browser.</p>
  
  <p>We are considering using a table in the DB itself, not <code>#temptable</code>. Also, other users may be able to be editing the same table but with different "data". We thought that <code>#temptable</code> would belong to a specific user (from the browser).</p>
  
  <p>Any guidance will be appreciated.  Thanks...John.</p>
  
  <p>ANSWER : Based on @Faruq's explanation, we will use a normal DB table for each user.</p>