encryption in Sql and decryption in asp.net (for querystring) possible?

Question

I have a sql job that sends email to all users everynight. It has a footer with Unsubscibe link which opens the asp.net page. As a querystring, i want to add encrypted EmailID to the link. so i can decrypt and use it to update the database.

How can i use encryption in sql and decrypt in asp.net? Is it possible or is there any other way?

Thanks a lot guys, Remo

Try this nayyeri.net/how-to-encrypt-query-string-parameters-in-asp-net — Saif Khan
– Saif Khan, Commented Apr 20, 2011 at 14:50
FWIW encrypting query string parameters is security by obscurity and generally worthless. — Chris Marisic
– Chris Marisic, Commented Apr 20, 2011 at 14:56
Why go through the trouble of encryption/decryption when you are sending the user a link with their own email address in it? You could simply send the GUID for the row to be updated in the database instead, which would save considerable effort and net the same level of obfuscation. — tawman
– tawman, Commented Apr 20, 2011 at 14:56

veljkoz · Accepted Answer · 2011-04-20 14:52:19Z

2

You could use EncryptByKey and DecryptByKey sql functions (sql-server 2008). In ASP you can always send query to db for decrypting purposes.

answered Apr 20, 2011 at 14:52

veljkoz

8,5129 gold badges58 silver badges92 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

encryption in Sql and decryption in asp.net (for querystring) possible?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related