Question DataReader doesnt seem to retrieve the first row of data

[darkcat02]

hi everyone,

i got a big problem over my datareader here...
it always display the second row...

any ideas?? i cant see any problem at all on my coding.... or maybe i cant find it...

 

[cjard]

You're probably doing a call to Read() BEFORE you start looping

Ensure that it goes like:

reader = whatever.ExecuteReader()
While reader.Read()
  'loop
End While

Not like:

reader = whatever.ExecuteReader()

If Not[B] reader.Read() [/B]Then Exit Sub '[B]this will advance the reader to first row[/B]

While reader.Read() 'starts looping from row 2!
  'loop
End While

 

[darkcat02]

You're probably doing a call to Read() BEFORE you start looping

Ensure that it goes like:

reader = whatever.ExecuteReader()
While reader.Read()
  'loop
End While

Not like:

reader = whatever.ExecuteReader()

If Not[B] reader.Read() [/B]Then Exit Sub '[B]this will advance the reader to first row[/B]

While reader.Read() 'starts looping from row 2!
  'loop
End While

hahaha.. thank you thank you.. now i see my error.. it was supposed to be reader.hasrows... but i mistakenly type reader.read()... thanks again! ^__^

 

[cjard]

I always thought HasRows was pointless, because if ther are no rows to start with, Read() returns false straight away, so a While Read() would never run the loop