How to check whether Email Id Exists or not in asp.net

Posted by Ilayabharathi under ASP.NET on 3/24/2014 | Points: 10 | Views : 1161 | Status : [Member] | Replies : 1
I am designing a web form to insert data into sql database.I just want to check whether the email id is already exists or not.




Responses

Posted by: Sumit08 on: 3/24/2014 [Member] Starter | Points: 25

Up
0
Down
from this query you can check email id is already is exist opr not

if exists(select email from user_master where email=@email)
begin
raiserror('Email Already Exists',11,1,@email)
end

in your else part you can insert your data

Ilayabharathi, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response