how to compare a value from database with the textbox value

Question

I am using sql server 2005 and visual stdio 2008 i have a textbox in my page as txtEmailId i want to compare this value in database with email_id column[it is a primary key] to avoid inconsistence in database on a button click with out using custom validator

can you please elaborate what do you mean by "avoid inconsistence on a button click" — Shekhar_Pro
– Shekhar_Pro, Commented Dec 19, 2010 at 16:15

gbs · Accepted Answer · 2010-12-19 16:43:34Z

3

There are several ways.

1: Do a db query using sqlcommand like below:

    SqlDataReader reader = null;
SqlConnection conn = new SqlConnection("Yourconnectionstring");
    conn.Open();
    SqlCommand cmd = new SqlCommand("select * from yourtable where email_id=@emailid", conn);
cmd.Parameters.AddWithValue("@emailid",txtEmail.Text);
   reader = cmd.ExecuteReader();
    if(reader!=null && reader.HasRows){
    //email exists in db do something
    }

edited Dec 19, 2010 at 16:43

answered Dec 19, 2010 at 16:33

gbs

7,2665 gold badges47 silver badges70 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

user279521 · Accepted Answer · 2010-12-19 16:17:09Z

1

My syntax might be off, but is this what you are looking for?

if txtEmailID.Text == email_id
performActionA;
Else
performActionB;

answered Dec 19, 2010 at 16:17

user279521

4,81121 gold badges80 silver badges111 bronze badges

Comments

C J · Accepted Answer · 2010-12-19 17:04:43Z

0

SOLUTION :>

ValidateQuery = "Select [Email_Id] from Sign_Up where (Email_Id = '"+txtEmailId.Text+"')";
            SqlCommand Validatecmd = new SqlCommand(ValidateQuery, con);

            String validate_email;
            validate_email= (String)Validatecmd.ExecuteScalar();
            if (validate_email != null)
            {
                lblValidateEmail.Text = "YOUR EMAIL ID IS REGISTERD TRY DIFFERENT EMAIL ID ";
            }
            else
            {
                   // DO WHAT EVER U WANT
            }</code>

answered Dec 19, 2010 at 17:04

C J

4271 gold badge10 silver badges34 bronze badges

Collectives™ on Stack Overflow

how to compare a value from database with the textbox value

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related