title: Referencing an entire data set instead of a single Cell
body: <p>I am creating a login form for users to log into using a database. I was wondering if there is a way in which i could get the program to search the entire table instead of a certain item. Here is my code so far.</p>
  
  <pre><code>Dim UserInputtedUsername As String
      Dim UserInputtedPassword As String
  
      UserInputtedUsername = txtAdminUsername.Text
      UserInputtedPassword = txtAdminPassword.Text
  
      sqlrunnerQuery = "SELECT * FROM tblLogin"
      daRunners = New OleDb.OleDbDataAdapter(sqlrunnerQuery, RunnerConnection)
      daRunners.Fill(dsRunner, "Login")
      If UserInputtedUsername = dsadminlogin.Tables("Login").Rows(0).Item(2) And UserInputtedPassword = dsadminlogin.Tables("Login").Rows(0).Item(3) Then
          Form1.Show()
      ElseIf MsgBox("You have entered incorrect details") Then
      End If
  End Sub
  </code></pre>