So my code lets you send an email if acctnum, userfirst, and userlast are correct...
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)
'txtFN.Text = dr.Item(1).ToString
'txtLN.Text = dr.Item(2).ToString
Session("USERNAME") = dr.Item(3).ToString
Session("PASSWORD") = dr.Item(4).ToString
...
Go to the complete details ...