The multi-part identifier "sumi@yahoo.com" could not be bound
<pre><code>            if (validateEmailId(email))
            {
                pictureBox5.Visible = true;
                SqlConnection con = new SqlConnection("conection string");
                SqlCommand cmd2 = new SqlCommand("UPDATE  sumant SET email=" + email + " WHERE code ='" + textBox2.Text + "' ", con);
                cmd2.Connection = con;
                cmd2.Connection.Open();
                cmd2.ExecuteNonQuery();//line 7
                con.Close();
            }
</code></pre>

<p>validateEmailId is a function which validates the email entered(using regular expression)..
The email entered in the 'email' textbox is validated and is returned to the above function..</p>

<p>now when the control passes to line 7 following error is encountered:
The multi-part identifier "sumi@yahoo.com" could not be bound.</p>

<p>it means sumi@yahoo.com ha passed the validation test bt in line 7 a problem occurs..</p>

<p>at the sql end,d column 'email' has varchar(50) as its data type...i dont think that's an issue....</p>

<p>please hep with the error
thanx!!</p>
