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