Hi,

I'm looking to generate 4 unique random numbers to be sent in 4 seperate emails when a user registers with a website. I also need to check these numbers don't already exist within an sql server table?

Can ayone give mne some help?

Thanks

Use the System.Random class:

http://msdn.microsoft.com/library/de...ClassTopic.asp

Put your check in a loop that checks the database for existance.

Of you could generate a GUID that will always be unique and you don't need to hit the database at all.

-Peter