SQL query Lookup for Newbie

[Newbie!]

Hi Group,

Im writting a small Username/Password verification into my Database.

I have a cboBox which is Populated from my dataset which has "SELECT
[Password], UserName, SystemUsersID FROM SystemUsers" in it.

In My Login Button I have:

Dim Password As String
******
If txtPassword.Text=Password Then
Success
Else
Failed
End If

My Database is a Access Database. I know i Need to put "Password=????? SQL
QUERY ?????" where the ******'s are but I don`t know exatly what.

Could anybody please point me in the right Direct?

I know it must be something like "Password = SELECT [Password], UserName,
FROM SystemUsers".

I`ve search all over but just carn`t find any examples

Thanks in Advance

Ta
Si

 

[Jim Mirra]

I think you are looking for:

dim auth as boolean = false
dim strSQL = "Select * from systemusers where password = '& txtPassword.Text
& "'"
Dim connect as new SqlConnection([place connection string here])
Dim objCmd as new sqlcommand(strSQL, connect)
Dim objDR as SqlDataReader
objDR = objCmd.ExecuteReader()

while objDR.Read()
auth = true
End While

if auth then
Success
else
Failed
end if
------
I use SQL this may have to be modded for oledb instead of SqlClient when
using accesss

HTH,

Jim Mirra