I have this simple vb code to pull out each row in the database as requested.
dbAD.SelectCommand = New OleDbCommand(“SELECT * FROM Profile ORDER BY Name ASC", dbConnect)
If dbRS.Tables("Profile").Rows.Count > 0 Then
For Each profile As DataRow In dbRS.Tables("Profile").Rows
Response.Write(“Profiles: “ & Profile(“FullName”) & “ “ & Profile(“Email”) & “ “ & Profile(“Password”) & “ “ & Profile(“Academy”) & “<br />”)
SELECT * from Profile WHERE FullName = Mary Jones
Consider reading about basic SQL queries but yes you need to place a
WHERE condition for a better efficient query like
SELECT * from Profile WHERE FullName = 'Mary Jones'
Again since you want only
password field consider getting only that field instead
SELECT `password` from Profile WHERE FullName = 'Mary Jones'
Though, you can get that specific field at your application end from the