Missing first record - datareader.read

[stustarz]

I am using:

 

If DataRead.Read() Then
               While DataRead.Read
                   cbCompList.Items.Add(DataRead.Item("competition"))
               End While
End If

 

The problem is when it runs, the datareader populates the combo box but skips the first record in the table. Does anyone know a way I can have all records returned.

 

Thanks

[mhsueh001]

Try

 

Try getting rid of the line with the If statement

 

In other words try just:

 

While DataRead.Read

cbCompList.Items.Add(DataRead.Item("competition"))

End While

[stustarz]

That will work, and maybe I never explained fully enough - the reason I have the IF statement is to check for EOF. The While statement doesn't, as far as I can see, check for this. So if my table has no records it will return 0 records but I want a way of catching this and displaying a msgbox e.t.c.

[mhsueh001]

Then possibly try:

 

If DataRead.Read() Then
               cbCompList.Items.Add(DataRead.Item("competition"))
               While DataRead.Read
                   cbCompList.Items.Add(DataRead.Item("competition"))
               End While
End If

[stustarz]

It works - fantastic thanks!

[a_jam_sandwich]

bear in mind every time anything uses the dataread.read the pointer for the data will move forward one record.

 

Andy

[Nerseus]

You should use the following. You don't need the "If"

While DataRead.Read
   cbCompList.Items.Add(DataRead.Item("competition"))
End While

 

According to the Help, the DataReader begins before the first record. The first call to Read advances the pointer to the first record but only if it exists. If it doesn't the Read method returns false and you'll never get in your While loop.

 

-Nerseus