title: bad idea to store DataTable object in asp.net session
body: <p>I understand that storing DataTable in session variable in asp.net is bad since it will use a lot of server's memory.  What I don't understand is that then what do you do when:</p>
  
  <ol>
  <li>User comes to a page where it requires to load a DataTable object (from SQL Server).</li>
  <li>User clicks on radio button for simple event (Ex. some controls get disabled).</li>
  <li>If you don't save the DataTable object in the session, you have to load it from the SQL server again upon postback on same page instead of just fetching it from the session?</li>
  </ol>
  
  <p>Thanks for help.</p>