Do While Skip In Selecting...

Hello:





I have one table and it contains a column named ID Number, and a column named Date. I have a Do While statement that runs a SQL select statement a few times based on the number of records with the same ID Number. During the Do While statement the information is copied into another table and deleted from the old table. After I look at the results, I see that at the second Do While loop, the data was not selected and the Select statement did not run... so the old variable value from varValue is used again... Any reasons on why?





Here is a code snippet of what is going on:


Do While varCount < varRecordCount


conSqlConnect.Open()


cmdSelect = New SqlCommand ("Select * From temp_records_1 where [id number]=@idnumber and date<@date", conSqlConnect)


cmdSelect.Parameters.Add( "@accountnumber", "10000" )


cmdSelect.Parameters.Add( "@date", dtnow )


dtrdatareader = cmdSelect.ExecuteReader()


While dtrdatareader.Read()


If IsDbNull(dtrdatareader("value")) = false Then


varValue = dtrdatareader("value")


End If


End While


dtrdatareader.Close()


conSqlConnect.Close()





'#####The information above is copied to another table here


'#####The record where the information was received is deleted.





varCount = varCount + 1


LoopAny ideas?