forum

home / developersection / forums / emailid already exists

emailid already exists

chetan kambli 1785 15-Nov-2016

If email is alredy exists in the database then it should show a ms g as emailid alredy exists..i wanted to write this code using asp.net ajax or javascript...

asp.net

Updated on 16-Nov-2016

chetan kambli

Other

Message

Can you answer this question?

Answer

1 Answers

Abhishek Srivasatava

16-Nov-2016

Hi Chetan,

To check email exist or not you can follow this code:

            SqlCommand cmd = new SqlCommand("Select email from User_information where email = @email", con);
            DataTable dt = new DataTable();
            cmd.Parameters.AddWithValue("@email", EmailBox.Text);
            SqlDataReader read = cmd.ExecuteReader();
            read.Read();
            if (read.HasRows)
                    {
                 MessageBox.Show("Email already exist ", "Error Message");
                    }
                    else
                    {
                     // ...
                    }

forum

emailid already exists

chetan kambli

Can you answer this question?

1 Answers

Liked By