Username/email availability

I need to check an SQL Server database (not asp.net membership) to see if an email is already in use before allowing the user to register.

I have tried using the information in this website but it does not seem to work.

Your help will be much appreciated