How to make dr.Read();
start reading again from the beginning if a condition is satisfied?
Something like:
SqlDataReader dr = command.ExecuteReader();
for(int i=0; dr.Read() ; i++){
if(condition ){
//let dr.Read() start reading from the beginning
}
}
You can't.
The *DataReader
classes are forward-only iterators.
Instead, you can store the results in a List<T>
(or a DataTable
)