Password System

[MAX1990]

I am newbie here. I need some help regarding password matter.
like how to matching password after make a password
I am making some banking systemeg: password is 45by89ki
how to matching the password in text

another problem is how to save data automatically into access

[OuTCasT]

Create a function to validate the password inserted in the textbox to the one stored in the database

Private Function ValidateCompany(ByVal passWord As String) As Boolean
        Dim conn As SqlConnection
        Dim cmd As SqlCommand
        Dim lookupPassword As String
 
        lookupPassword = Nothing
 
        ' Check for an invalid userName.
        ' userName  must not be set to nothing and must be between one and 15 characters.
        If ((passWord Is Nothing)) Then
            MsgBox("Incorrect Company Password, Please Try again.", MsgBoxStyle.Critical)
            Return False
 
        End If
        Try
            ' Consult with your SQL Server administrator for an appropriate connection
            ' string to use to connect to your local SQL Server.
 
            conn = New SqlConnection("Server=(local);Data Source=.\sqlexpress;Initial Catalog='" & TextBox1.Text & "';Integrated Security=True")
            conn.Open()
 
            ' Create SqlCommand to select pwd field from the users table given a supplied userName.
            cmd = New SqlCommand("SELECT CompanyPassword from CompanyParameters where CompanyPassword=@CompanyPassword", conn)
            cmd.Parameters.Add("@CompanyPassword", SqlDbType.VarChar, 25)
            cmd.Parameters("@CompanyPassword").Value = passWord
 
 
            ' Execute command and fetch pwd field into lookupPassword string.
            lookupPassword = cmd.ExecuteScalar()
 
            ' Cleanup command and connection objects.
            cmd.Dispose()
            conn.Dispose()
        Catch ex As Exception
            ' Add error handling here for debugging.
            ' This error message should not be sent back to the caller.
            MsgBox("Incorrect Company Password, Please Try again.", MsgBoxStyle.Critical)
        End Try
 
        ' If no password found, return false.
        If (lookupPassword Is Nothing) Then
            ' You could write failed login attempts here to the event log for additional security.
            Return False
        End If
 
        ' Compare lookupPassword and input passWord by using a case-sensitive comparison.
        Return (String.Compare(lookupPassword, passWord, False) = 0)
 
    End Function 

on a button click you would call the function

If ValidateCompany(txtPassword.Text) Then
........
else
If ValidateCompany(txtPassword.Text) = false Then
end if

[debasisdas]

if userid & password is stored in database then

1.make userid the Primay key (to avoid duplicate or null entry)
2.check the userid/password from frontend after user input by using COUNT in database
3.proceed further on successful login else reprompt to enter the correct username/password.