title: How to retrieve multiple values of single column in session
body: <p>Each user on my website has a <code>reg_id</code>. There are some <code>emergency_contact_id</code>'s associated with this <code>reg_id</code>.</p>
  
  <p>For example:</p>
  
  <pre><code>EmerContact_id  Reg_id    
    91              1    
    92              1    
    93              1    
    94              1    
    95              1
  </code></pre>
  
  <p>Now I want to store these <code>EmerContact_id</code>'s into session like this:</p>
  
  <pre><code>Session["Emer1"]    
  Session["Emer2"]    
  Session["Emer3"]    
  Session["Emer4"]    
  Session["Emer5"]
  </code></pre>
  
  <p>How can I achieve this?</p>
  
  <p>I am thinking of using:</p>
  
  <pre><code>while(reader.read()) { ... }
  </code></pre>
  
  <p>But I don't know how to use it.</p>