So right now my page asks for acctnum, first name, and last name and if they are correct sends an email
However, I want to use my message box below to show when
1) Message Sent
2) Info is not correct
3) No account number filled in
Public Sub CHECKACCTINFO()
SqlForgotPass.SelectCommand = "SELECT ACCTNUM, USERFIRST, USERLAST, USERNAME, PASSWORD, EMAIL" & _
" FROM FTPUsers WHERE ACCTNUM='" & txtActNum.Text & "' AND USERFIRST='" & txtFN.Text & "' AND USERLAST='" & txtLN.Text & "'"
Dim dv As DataView = CType(SqlForgotPass.Select(DataSourceSelectArguments.Empty), DataView)
If dv.Count > 0 Then
Dim i As Integer = 0
Do Until i = dv.Count
Dim dr As DataRowView = dv.Item(i)
Session("USERNAME") = dr.Item(3).ToStr ...
Go to the complete details ...