First you must create a User table in the database with a type column Active = falsein the database (the type of the database field is 1 bit). Then, after the user has created his account, you should send him an activation link with a query string containing the user's activation instructions. Sort of:
Please activate your account www.mysite.com?id=21EC2020-3AEA-1069-A2DD-08002B30309D
On the confirmation page, you check this request, for example
var id = Response.QueryString["id"]
if (id!= null) userBL.ActivateUser(id);
The ActivateUser () method will update the field to true, and also send a confirmation email.
source
share