i require to connect 2 DataReader objects in succession to the same connection object .

but its not allowing me to do so.

error generated is :

"There is already an open DataReader associated with this Connection which must be closed first"


instead of using DataReader , if i use DataAdapter object , it works .

what is the correct and efficient way to read through records ?