title: How can I fix this error in my C# and T-SQL code
body: <p>I fill a data table with a SQL query and I get this error:</p>
  
  <blockquote>
    <p>System.Data.SqlClient.SqlException: 'Incorrect syntax near '='.</p>
  </blockquote>
  
  <p>Here is my code:</p>
  
  <pre><code>SqlConnection sqlConnection = new SqlConnection("Data Source=OWNER;Initial Catalog=train-database;Integrated Security=True;Pooling=False");
  SqlDataAdapter sda = new SqlDataAdapter("SELECT c_id FROM [user] WHERE E_mail = '"+ f3.E_Mail3.Text +"' and password = "+f3.Password3.Text+" ", sqlConnection);
  
  DataTable dt = new DataTable();
  sda.Fill(dt);
  </code></pre>