Hello All,

First of all I am new to .NET. I am trying to create a login (login2.aspx) form that checks an Access database table (called user) to see if the user is a valid user or not. I have seen examples, but they hard code the user/password into the page or they only check one field. I need to check both fields (username and password).

Please any help is greatly appreciated,

Thanks in Advance,
Mark.

Where do u want to check ur user & Password from?! do u use any DB?!

Always:),
Hovik Melkomian.

Assuming you brought back the results to a data table:

Dim strSQL As String = select * from Users where username = '" & txtUserName.Text & "' and password = '" & txtPassword.Text & "'"
'.. load the data to a dataset or datatable, not shown here ..

if (objTable.Rows.Count > 0 ) then
  'User exists
else
  'User doesn't exist with a valid user id or password
end if

If you want to display a separate message for user id/password problems, then you need to bring the results back based on user ID, and then check the password (if (objtable.rows(0).Item("Password") = strPassword)) in your code.

Brian

    Function DBAuthenticate(ByVal strUsername As String, ByVal strPassword As String) As Integer
        Dim bResult As Boolean = False
        Dim objConn As New OleDbConnection(ConfigurationSettings.AppSettings( "myDB"))
        Dim strSQL As String
        Dim strGoodPassword As String
        Dim objCommand As New OleDbCommand

        objCommand.Connection = objConn
        strSQL = String.Format("SELECT p_w FROM myDB WHERE (email='{0}');", strUsername)
        objCommand.CommandText = strSQL
        objCommand.CommandType = CommandType.Text

        objConn.Open()
        strGoodPassword = CType(objCommand.ExecuteScalar, String)
        objConn.Close()

        If Not strGoodPassword Is Nothing Then
            If strGoodPassword = strPassword Then
                bResult = True
            Else
                lblMessage.Text = "Invalid Login!"
                lblMessage.Text &= " If you are not a member please click the above link to register."
            End If
        Else
            lblMessage.Text = "Invalid Login!"
            lblMessage.Text &= " If you are not a member please click the above link to register."
        End If

        Return bResult
    End Function

This function takes the username and password passed to it from the "Button1_Click" Sub and checks to see if they are valid. (written by PLanoie)

Thanks to all that replied. I have it working. and works great.

Thanks again.
Mark