doubt(user account activation)

Question

i have a doubt regarding email verification....after an user registers at the site an email goes to his inbox showing his userid,password and a link to activate his account....suppose if the user clicks the link 2nd time how the program detects his account has already been activated and one more thing when he logs into the site and if the account has not been activated how the program detects his account has not been activated
if anybody does have a sample code please post here or explain the concept

Answer 1

Hi Kiran,

I hope you save the username and password of the user in database. So, you can add another column called 'Activated' to the same table.

Then when you create a user you have the value 0 in that column.

Once the user click on the link, you can update it to 1.

So if the user clicks on it for the second time, you can check the value and as it is already 1, you know the user has clicked on it for the second time.


When he logs into the site, you can again check the value. If it is 0 you know the account is not activated.


If you find this helpful, please tick 'Do you like this answer' checkbox.

Answer 2

ok, niki your answer is appreciated ok after clicking the link do i need to open up connection to my database???
  string userID = Request.QueryString["id"];

so after this statement basing on id value supplied in the query string do i need to open up connection to db and update the activated flag in my table???  
 is there any alternate method using membership api??