transaction stoppage or resume

[netsooz Amir Hamidi]

Hi folks I'm building this registration system in my asp application and I've got a question. I'd be happy if you provide me with an answer. I have a code block to check if the entered email exists or not. I've used executeScalar method here. so when the email exists I receive a ONE. now I made an if block telling the machine to print an error then and stop the process. because I'm putting the main process (saving user to DB) after this checkpoint, HOW can I stop the code blocking from process(going on to insertation) if email exists before? I mean I want the transaction to stop if email exists and this requires I think something like break; or ... . can you help me?

Proper Prepration Prevents Poor Performance! h

[Blue_Boy]

I think this validation is better to do on DB. But, instead

break

use

return

---

I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post. www.aktualiteti.com

modified on Sunday, May 23, 2010 6:05 PM