CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2012
    Posts
    1

    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???

  2. #2
    Join Date
    Jun 2005
    Location
    JHB South Africa
    Posts
    3,772

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  





Click Here to Expand Forum to Full Width

Featured