These are the step involved.
1. Send the activation link that should be redirecting to your desired page. ex. www.abc.com\activation.aspx?id=unique value
The unique value can be only for one user.
2. In the page load event of the form "activation.aspx" get the unique value using query string.
3. Use the update query to activate the user.
ex. Update UserTable Set UserStatus = 'Activated' where UniqueValue ='xyz'
Thanks