Validation of Password

See more:

ASP.NET

Hi,

I have an application with MS-Access as backend.
When i checked entered password with database password, the system ignore cases (let me give an example, actual password is Test but if i type test/TeSt/TEST also it is allowing me to login.)
How to fix this ?

any help ?

here is my code

Try
            cn.Open()
            cmd = New OleDbCommand("select *from Login where uname='" & TextBox4.Text & "' and pwd='" & TextBox3.Text & "'", cn)
            rs = cmd.ExecuteReader
            If rs.HasRows Then
                Session("validated") = True
                Response.Redirect("home.aspx")
            Else
                Label4.Visible = True
                Label4.Text = "Wrong UserName or Password, Try Again!!"
                TextBox3.Focus()
            End If
            cn.Close()
        Catch ex As Exception
            cn.Close()
        End Try
        If TextBox4.Text = "" Then
            Label4.Visible = True
            Label4.Text = "Please Enter UserName"
        ElseIf TextBox3.Text = "" Then
            Label4.Visible = True
            Label4.Text = "Please Enter Password"
            TextBox3.Focus()
        End If