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
)
The only way to restart it is to grab a new reader with ExecuteReader()
.
You can do that by first closing the datareader using dr.close();
then initializing it again.
If(condition)
{
dr.close();
dr=command.ExecuteReader();
}
Where command is the MySqlCommand
object.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With