title: How to loop through rows in a Datatable?
body: <p>I'm having some trouble getting a loop to see more then just the first row of data. The referenced dataset function gets all the required rows with no problem therefore I'm sure the problem must be with the code.</p>
  
  <pre><code>Dim dtLogin As System.Data.DataTable
      Dim userDetails As New dsMembersTableAdapters.mi_membersTableAdapter
      Dim rowsLogin As System.Data.DataRow
  
      'Fill datatable using method from dataset
      dtLogin = userDetails.GetUserData()
  
      'Find cotrols hidden in Login View
      Dim user As String = txtUser.Text
      Dim pass As String = txtPass.Text
  
      'Search all users
      For Each rowsLogin In dtLogin.Rows
          'Find Username Entered
          If user = dtLogin.Rows.Item(0).Item(1) Then
              'Checks users password matches
              If pass = dtLogin.Rows.Item(0).Item(2) Then
                  If dtLogin.Rows.Item(0).Item(6) = 1 Then
                      'Log User In
                      FormsAuthentication.RedirectFromLoginPage(dtLogin.Rows.Item(0).Item(1), True)
                  Else
                      'Account Not Active Message
                      lblValidation.Text = "There is a problem with your account, please contact the website administration"
                  End If
              Else
                  'Incorrect Password Message
                  lblValidation.Text = "Incorrect Password"
              End If
          Else
              'No User in DB Message
              lblValidation.Text = "No User Found" + dtLogin.Rows.Item(0).Item(1)
          End If
      Next
  </code></pre>
  
  <p>If anyone could help at all or point me in the rihgt direct that would be fantastic! Thanks in advance :)</p>