Account Activation Login Module

You should check whether person is activated or nor or else display activation message

In my coding it will always show invalid login. Where is the error in coding. How can i fix it.

You can return different status and then catch them using ExecuteScalar in a string variable and then using switch or IF Else you can do different actions

Invalid - Invalid login

InActive - Not activated

Valid - Valid login

Try             con.Open()             Dim cmd As New SqlCommand("select status from signup where name =" & "'" & txtname.Text & "'" & "and password=" & "'" & txtpassword.Text & "'", con)             Dim status As String = cmd.ExecuteScalar()             If status Is Nothing Then                 Label1.Text = "Invalid Login. Please Try Again!"

            ElseIf status = "Pending" Then                 Label1.Text = "Account Not Acctivated"             Else                 Response.Redirect("eshop.aspx")             End If Catch ex As Exception             Label1.Text = "Error --> " & "Invalid Password. Please Try Again!"         Finally             con.Close()         End Try

if status is nothing then it show invalid login but when status is Pending or else it redirect to other page. Please correct my coding

Your code is correct you should try checking

 If status Is Nothing Or status = ""