January 3rd, 2012, 04:40 AM
sending email verification link with database updation
i have popup on my webform with name and email id submit button,So when u click on submit button the name n email is entered into SQLSERVER database.
As user click on submit a verification link should be sent to him
table named "SUBSCRIBE" in database having columns :Name,Email,DateTime,Validated,ValidationEmailSent,Validation code
where name n email will come from as user entered....but others has to b generated
where validation=if clicked on link den 1 otherwise 0;
validation Email = if email id is proper value is 1 not proper value should be 0;
validation code is ramdom no;
values of this 3 columns will b updated in database as per user response.
How to write code for this problem as i have never used database sql server???
January 9th, 2012, 02:48 AM
Re: sending email verification link with database updation
Most of the Validating needs to be done in your code and not the SQL server.. (SQL stores the data and does only simple verification..
for validating the Email research Regular expressions...
Random Numbers look up RND()..
and the validated column would only be set if the linked URL Parameters match the Email/Username and the Random No...
Articles VB6 : Break the 2G limit - Animation 1, 2 VB.NET : 2005/8 : Moving Images , Animation 1 , 2 , 3 , User Controls
WPF Articles : 3D Animation 1 , 2 , 3
Code snips: VB6 Hex Edit, IP Chat, Copy Prot., Crop, Zoom : .NET IP Chat (V4), Adv. ContextMenus, click Hotspot, Scroll Controls
Find me in ASP.NET., VB6., VB.NET , Writing Articles, My Genealogy, Forum
All VS.NET: posts refer to VS.NET 2008 (Pro) unless otherwise stated.
Click Here to Expand Forum to Full Width