title: the multi part identifier a@gmail.com could not bound
body: <p>The email column is at no 4 in the table
  And the data type is varchar
  con.Open();</p>
  
  <pre><code>    cmd = new SqlCommand("select * from UserInfo where EMail=" + EMail + "", con);
      SqlDataReader dr;
  
      dr =cmd.ExecuteReader();//here I get error
      while (dr.Read())
      {
  
          lblCustName.Text = dr[1].ToString();
          lblAddress.Text = dr[2].ToString();
          lblMobNo.Text = dr[3].ToString();
  
          lblEMail.Text = dr[4].ToString();
          //con.Close;
  
      }
  </code></pre>