title: How to read a recordset multiple times?
body: <p>I have stored an ADO recordset in a DataTable. I have iterated to its end. In the same code, I want to reiterate it, but it gives me an error - </p>
  
  <pre><code>Error: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---&gt; System.IndexOutOfRangeException: There is no row at position -1.
     at System.Data.RBTree`1.GetNodeByIndex(Int32 userIndex)
     at System.Data.RBTree`1.get_Item(Int32 index)
     at System.Data.DataRowCollection.get_Item(Int32 index)
  </code></pre>
  
  <p>I looked here - <a href="http://www.techrepublic.com/blog/10-things/10-plus-mistakes-to-avoid-when-using-vba-recordset-objects/" rel="nofollow">http://www.techrepublic.com/blog/10-things/10-plus-mistakes-to-avoid-when-using-vba-recordset-objects/</a>
  But it does not give me an exact method to move the "row pointer" back to the 1st row.</p>
  
  <p>How do I do this ?</p>