How can i Move to the Next Record?

[ewankosayo]

Hi can anyone help me how can i move to the next record?

While Reader.Read
For Each Row As DataRow In Table.Rows
If Reader("UserID") = Row("UserID") Then
' I need to Move to the next Row here..
' How can i Move to the Next Row?
Else
Dim Item As New ListViewItem
Call Item.SubItems.Add(Reader("Name"))
Call Item.SubItems.Add(Reader("UserID"))
Call ListView1.Items.Add(Item)
End If
Next
End While

Thanks..

[balabaster]

Hi can anyone help me how can i move to the next record?

While Reader.Read
For Each Row As DataRow In Table.Rows
If Reader("UserID") = Row("UserID") Then
' I need to Move to the next Row here..
' How can i Move to the Next Row?
Else
Dim Item As New ListViewItem
Call Item.SubItems.Add(Reader("Name"))
Call Item.SubItems.Add(Reader("UserID"))
Call ListView1.Items.Add(Item)
End If
Next
End While

Thanks..

Reader.Read is a method that advances the record to the next and returns a boolean. If an advance was successful, true is returned, if not, false is returned. Consequently While Reader.Read automatically advances the record on every iteration of your loop. If you need to advance the record inside your loop - add the line Reader.Read in the position you need the advance.

[ewankosayo]

Thank you for the information,
My concern is I need to move the record to the next row of my table.

[balabaster]

So you basically want to continue your loop at the next iteration of your For Each Row...blah blah blah. You've already got a For Each advancing your rows...so just Continue For your loop will exit to the next iteration

 For Each Row As DataRow in Table.Rows 
  If Row("User") = Reader("User") Then Continue For 'Jumps straight to Next
 
  'Do stuff not attributed to moving on to the next user
 
Next
 

[ewankosayo]

Yes that’s what I wanted to jump to the next row of my table row.
What is the code to jump straight to my next?

[ewankosayo]

I’m using visual studio 2003.

[ewankosayo]

I don’t think that Continue Function exist in V.S 2003

[balabaster]

I don’t think that Continue Function exist in V.S 2003

So what about using flow control to do this? You're basically saying that if your user id matches then don't do this stuff but go on to the next iteration of your loop...which could be said as: so long as your user id's don't match then do this stuff.

Pseudo code:

For Each Row in Rows 
  If Not Row("User") = Reader("User")
    'Do stuff
  End If
Next
 

[ewankosayo]

For Each Row in Rows
If Not Row("User") = Reader("User")
'Do stuff -> i need to go to the next record here that's what i wanted to do here


End If
Next

[ewankosayo]

first see my first post i'm in reader loop.

[balabaster]

Hi can anyone help me how can i move to the next record?

While Reader.Read
For Each Row As DataRow In Table.Rows
If Reader("UserID") = Row("UserID") Then
' I need to Move to the next Row here..
' How can i Move to the Next Row?
Else
Dim Item As New ListViewItem
Call Item.SubItems.Add(Reader("Name"))
Call Item.SubItems.Add(Reader("UserID"))
Call ListView1.Items.Add(Item)
End If
Next
End While

Thanks..

Okay, obviously I need to spell it out from scratch:

First of all Reader is not a loop and neither is Reader.Read...While is the loop. Reader.Read is just an instruction that tells the datareader to read the next row of the recordset. The method "Read" returns a boolean value indicating that the reader successfully read the next row. If you want to advance to the next reader record you just use Reader.Read like so:

While Reader.Read 
For Each Row As DataRow In Table.Rows
    If Reader("UserID") = Row("UserID") Then
     'If you just want to skip to the next reader record and continue on 
     'then do the following:
     Reader.Read 
     'Or if you want to skip the rest of the For loop and go on to the
     'the next iteration of your While loop then do the following:
     Exit For
    Else
     Dim Item As New ListViewItem
     Call Item.SubItems.Add(Reader("Name"))
     Call Item.SubItems.Add(Reader("UserID"))
     Call ListView1.Items.Add(Item)
    End If
Next
End While

I already stated that this is what you had to do in my first response. I don't think I can explain it any clearer than that. Good luck.