title: C# Syntax error (missing operator) in query expression
body: <p>I receive this error on <code>cmd.ExecuteNonQuery()</code>... I think I am wrong on <code>cmd.CommandText</code>...</p>
  
  <blockquote>
    <p>Syntax error (missing operator) in query expression 'Nr_Crt='1' and Varsta '3' and KG '2' and Specie 'Iepure' and Risc'Nu' and Tip1 'Diurn' and Tip2 'Carnivor''.</p>
  </blockquote>
  
  <pre><code>    private void button2_Click_1(object sender, EventArgs e)
          {
              if (txtNr_Crt.Text != " " &amp; txtVarsta.Text != " " &amp; txtKG.Text != " " &amp; txtSpecie.Text != " " &amp; txtRisc.Text != " " &amp; txtTip1.Text != " " &amp; txtTip1.Text != " " &amp; txtTip2.Text != "")
              {
  
                  cn.Open();
                  cmd.CommandText = "DELETE from Animale Where Nr_Crt='" + txtNr_Crt.Text + "' and Varsta '" + txtVarsta.Text + "' and KG '" + txtKG.Text + "' and Specie '" + txtSpecie.Text + "' and Risc'" + txtRisc.Text + "' and Tip1 '" + txtTip1.Text + "' and Tip2 '" + txtTip2.Text + "'";
                  cmd.ExecuteNonQuery();
                  cn.Close();
  
                  loaddata();
  
                  txtNr_Crt.Text = "";
                  txtVarsta.Text = "";
                  txtKG.Text = "";
                  txtSpecie.Text = "";
                  txtSex.Text = "";
                  txtRisc.Text = "";
                  txtTip1.Text = "";
                  txtTip2.Text = "";
              }
          }
  </code></pre>