data reader

[ss123]

hi, i'm using two data reader to read from the same table, one can execute correctly, but one only can retrieve the end of record. Anyone have idea?
For i = 0 To 259
myReader.Read()
x = (myReader.GetDateTime(0)).ToOADate
y = myReader.GetDouble(1)
ppl.Add(x, y)
Next
For i = 0 To 259
myReader2.Read()
j(i) = myReader2.GetDouble(1)
Next
Dim t As Double
For i = 0 To 259
If i = 249 Then
Exit For
Else
myReader2.Read()
MessageBox.Show(myReader2.GetDateTime(0))
t = (myReader2.GetDateTime(0)).ToOADate
k = ((j(i) + j(i + 1) + j(i + 2) + j(i + 3) + j(i + 4) + j(i + 5) + j(i + 6) + j(i + 7) + j(i + 8) + j(i + 9)) / 10)
ppl2.Add(t, k)
End If
Next

 

[hadinatayp]

how about changing the for statement to:

while reader.read()
     'statements
end while

 

[Administrator]

You can only use one DataReader at a time. And it is suggested to use code such as:

While MyReader.Read()
'get data here
End While