ASP.NET

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

    If Not Page.IsPostBack Then

        Dim dr As OleDbDataReader

        Try

            'Here we will check from the passed querystring that if the email id/username and generated unique code is same then the panel for resetting password will be visible otherwise not

            cmd = New OleDbCommand("select UserName,myemail,[UniqueCode] from tblusers where [UniqueCode]=@uniqueCode and (myEmail=@emailid or UserName=@username)", con)

            cmd.Parameters.AddWithValue("@uniqueCode", Convert.ToString(Request.QueryString("uCode")))

            cmd.Parameters.AddWithValue("@emailid", Convert.ToString(Request.QueryString("myEmail")))

            cmd.Parameters.AddWithValue("@username", Convert.ToString(Request.QueryString("uName")))


            If con.State = ConnectionState.Closed Then

                con.Open()

            End If

            dr = cmd.ExecuteReader()

            If dr.HasRows Then

                ResetPwdPanel.Visible = True

            Else

                ResetPwdPanel.Visible = False

                lblExpired.Text = "Reset password link has expired.It was for one time use only"

                Return

            End If

            dr.Close()

            dr.Dispose()

        Catch ex As Exception

            lblStatus.Text = "Error Occured: " & ex.Message.ToString()

        Finally

            cmd.Dispose()

            con.Close()

        End Try

    End If

End Sub