I have the following code which is used to authenticate a username & password however it always returns invalid username.
Private Function VerifyPassword(SuppliedUsername As String, SuppliedPassword As String) As Boolean
Dim passwordMatch As Boolean = False
' Get the salt and pwd from the database based on the user name.
' See "How To: Use DPAPI (Machine Store) from ASP.NET," "How To:
' Use DPAPI (User Store) from Enterprise Services," and "How To:
' Create a DPAPI Library" for more information about how to use
' DPAPI to securely store connection strings.
Dim ConnString As [String] = ConfigurationManager.ConnectionStrings("HostLinkConnectionString").ConnectionString
Dim con As New SqlConnection(ConnString)
Dim cmd As New SqlCommand()
cmd.CommandType = CommandType.StoredProcedure
cmd.CommandText = "spL ...
Go to the complete details ...