retrieve password function

[ssfftt]

--------------------------------------------------------------------------------I am making an user login screen , the login function works fine. Now i need another function which allows user to retrieve password. My idea is that user can click on a button "forgot password?", the application will go to database look for match of input user name, if there is no match, gives error (I am capable to do only up to this point). else if input name matchs database record, the corresponding password question (setup by user during registration) will show up and ask user for answer. Then application will check the input answer. if no match, gives error, if yes, show the password.btw, I'm using MSSQL dbcan any one help me plz? (plz be more specific in code because I am new to VB.NET)Thanks in advance

 

[ManicCW]

Well it's the same procedure as loging. When database find userr name show question in textbox or label and when the user inputs answer run funczion to check it like you did with password (same thing). Use ExecuteScalar with parameters. There is similar post at:

http://www.vbdotnetforums.com/showthread.php?t=6100