Multiple logins

[FadetoBlack]

I have a table in sql server with some member id and passwords ,I need to verify the validity.I wrote the cose for a single user /password the code im pasting below.Im just stuck when there are multiple users .Just need a lil bit of help in this .Thx

str = "select  uid ,pass from members where UID='" & TextBox1.Text & "' AND PASS='" & TextBox2.Text & "'"

        comm = New SqlCommand(str, conn)
        Dim dr As SqlDataReader = comm.ExecuteReader



        Try
            If dr.Read = False Then
                MessageBox.Show("Wrong Username/Password")
            Else
                MessageBox.Show("Login successfull")
            End If
        Catch ex As Exception
            MsgBox(ex.Message)
        End Try

 

[ManicCW]

str = "select  uid ,pass from members where UID='" & TextBox1.Text & "'

...
if dr.hasrows=true then
'USER EXISTS
while dr.Read
if dr("pass")=TextBox2.Text then
'USER OK
else
'USER BAD PASS
end if
end while
else
'USER DOES NOT EXIST
end if

 

[TechGnome]

Personaly I don't see anything wrong with the original code. The user name & passwrod combinations should be unique, so selecting by those should result in 1 (if they are in the table) or 0 (if they are not) results.

-tg

 

[FadetoBlack]

yeah , got the idea now .Thnks guys

 

[Paszt]

The ExecuteNonQuery function of the SqlCommand class would use less overhead. The function returns the number of rows affected.

 

[FadetoBlack]

onr more thing , how do i make the password acceptance case senstive ?

 

[ManicCW]

yeah, i would also need reply to that!