forum

Home / DeveloperSection / Forums / emailid already exists

Ask Question

emailid already exists

chetan kambli158615-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...
c#asp.net 
Updated on 16-Nov-2016
chetan kambli

chetan kambli

Follow

Can you answer this question?

Answer

1 Answers

Abhishek Srivasatava

Abhishek Srivasatava

16-Nov-2016
Hi Chetan,

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

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


Liked By