title: Does ADO Recordset need to be closed?
body: <p>I have an ADO recordset (not ADO.NET) that I populate in every iteration of a loop. 
  My question is: Do I need to close the recordset at end of every iteration so it gets populated with fresh data in next iteration OR I could just use the unclosed recordset to populate with new data in next iteration. Please look at code sample below.</p>
  
  <pre><code>set rs=Server.CreateObject("ADODB.recordset")
  
  for count = 0 to 3
  
    rs.Open "Select * from Customers where CustomerId = " &amp; count, conn
  
    'do some processing of data in recordset
  
    'rs.Close 'NOT VERY SURE IF I NEED TO DO THIS
  
  next
  </code></pre>