title: SqlDataReader inside SqlDataReader
body: <p>How can I implement a <code>SqlDataReader</code> inside another <code>SqlDataReader</code>?</p>
  
  <p>My problem is I have a <code>SqlDataReader</code>. I am issuing <code>while (reader.read())</code> and inside the while loop I have to create another <code>SqlDataReader</code> to read from the database. But I'm getting exceptions about connection being already open. </p>
  
  <p>So what's the best way to solve my problem?</p>
  
  <p>Edit:</p>
  
  <p>I am using clr to create my stored procedures. I tried to put <code>MultipleActiveResultSets=true;</code> within the connection string of both the clr and the project, and an exception occurred when I 
  tested my stored procedure on SQL Server:</p>
  
  <blockquote>
    <p>System.InvalidOperationException: There is already an open DataReader associated with this Command which must be closed first.</p>
  </blockquote>