This is a Visual Basic Windows Form App
I'm working on a forget password form, my idea is that the user enters their userID on a textBox and an email is sent to them with a one-time password.
I already have everything designed, but I don't know how to pull the email from SQL taking in consideration that the user will be entering only their userID on a textBox.
All the login and register functions are created and working. I have a sql table "users" with "userID, password and email".
You have to add new column that will contain recovery password. This column must be updated every time you send "I forgot my password" request.
Examples:
-- your table alredy exists
CREATE TABLE users ([userID] INT PRIMARY KEY IDENTITY(1, 1), [password] VARCHAR(100), email varchar(100));
-- Add new column to users table. This column will contain recovery password
ALTER TABLE users ADD recovery_password VARCHAR(100) NULL;
INSERT INTO users (password, email) VALUES ('Password #1', '[email protected]');
-- you have to use TextBox component with a Text property instead of "1" value
-- you have to create some algorythm to create encrypted password for recovery_password column
UPDATE users SET recovery_password = 'SECRET CODE' WHERE [UserID] = 1
And the last query that you looking for looks so:
-- Use this query to compare typed password by user and the recovery password
SELECT recovery_password FROM users WHERE [UserID] = 1
The same examples: db<>fiddle
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments