Simple activation email

[netsooz Amir Hamidi]

Hello there I'm having this registration form with 7 fields of real_name, user_name, email, password, city, webpage and signiture, I want my users to fill in this form and then after submitting the form I want to send them an activation email. my database has mentioned fields and also id (using identity) and verfy_user with default value of 0 (which means not). 2 questions are here for me: 1- how can I send activation email (simply?) 2- how can I prevent unactivate users from logging in? your responses will be highly appriciated

Proper Prepration Prevents Poor Performance! h

[Greg Chelstowski]

netsooz (Amir Hamidi) wrote:

1- how can I send activation email (simply?)

Look up System.Web.Mail or System.Net.Mail. There's loads of Smtp classes in there. And they're fairly simple.

netsooz (Amir Hamidi) wrote:

2- how can I prevent unactivate users from logging in?

Add a bit field in your users table (e.g. IsActive) and set it to true, when the user you're sending an activation email to clicks on the link in that email.

var question = (_2b || !(_2b));

[Abhijit Jana]

1. First user fill the registration form. 2. User Click on the submit button. 3. On submit button click, you send him a activation mail for his account. Now Following is my suggestion for your question.

netsooz (Amir Hamidi) wrote:

1- how can I send activation email (simply?)

Now, I will suggest, add one more filed called GUID in the DB. While sending the mail add the GUID with the corresponding user in the database and send the activation url. Send a URL link with the email like http://yourwebsite.com/Verification.aspx?Guid="AFDFASDFrwerwSDF@423" Now, This GUID will ensure that, weather the user coming from the proper source or not. When user hits the URL, Read the Query String and verify the user GUID from the database. Now if its valid, then set the verfy_user filed to 1 and redirect user to Home Page.

netsooz (Amir Hamidi) wrote:

2- how can I prevent unactivate users from logging in?

During login, Check verfy_user field along with the User ID and Password. If user ID and password matched but verfy_user is still 0, then throw a message that Please activate your account. Hope this will helps you to move ahead. Good luck.

cheers, Abhijit CodeProject MVP

[J4amieC]

Good answer, but just for the record:

Abhijit Jana wrote:

add one more filed called GUID

filed - as in my glass has been filed with wine [sic] field - as in my database field is "Username" Don't worry though. Most English people get confused with these english words which sound (and often look) the same but have different meanings.

[Expert Coming]

Filed actually means like a paper has been filed in a filing cabinet. Filled is filled with wine...

The best way to accelerate a Macintosh is at 9.8m/sec² - Marcus Dolengo

[Abhijit Jana]

:( Sorry about that.

cheers, Abhijit CodeProject MVP

[Expert Coming]

You simply made a spelling mistake, he even made one :P

The best way to accelerate a Macintosh is at 9.8m/sec² - Marcus Dolengo

[J4amieC]

Yes, notice I had [sic] after the sentence. I was using filed as it sounds not as its spelt.

[J4amieC]

No need to be sorry Abhijit, you gacve an excellent answer I was just pointing out a possible misunderstanding of the right English word to use... It seems I confused things more using your spelling of filed to mean filled instead of filed. :-D I hate English. I want to speak a cooler, less obtuse, language.

[J4amieC]

Yes, I confused things more. Im a douche.

[Abhijit Jana]

:)

cheers, Abhijit CodeProject MVP