reader.read count less than 1 value return by the sql server in asp.net

See more:

ASP.NET

hi all,

i have read some record form the sql db in which more than 20000 records.

my problem is when execute the code it return less than 1 record form the database

reader = SqlHelper.ExecuteReader(SqlHelper.ConnectionString_SimphonI, Data.CommandType.StoredProcedure, "dbo.pd_vs_Ins_Bookings_SELECT", sqlParam)
           If reader.Read Then
               While reader.Read
                   Dim obj As New CIns_Booking

                   If Not IsDBNull(reader("BookingID")) Then obj.BookingID = reader("BookingID")
                   
                   If Not IsDBNull(reader("Trip")) Then obj.Trip = reader("Trip")
                   If Not IsDBNull(reader("Source")) Then obj.Source = reader("Source")
                   objList.Add(obj)
               End While
           End If
           Return objList

but when i see by the profiler it retorn all rows as i want
how to solve it.

thanks