title: SQL Delete query not working properly
body: <p>I had a logic error in my sql <code>delete</code> query which would not give any error in visual studio and did not delete the record in the database</p>
  
  <p>Here is a snippet of my code</p>
  
  <pre><code>SqlCommand cmd = new SqlCommand(
     @"DELETE FROM table_name 
       WHERE item_id=" + itmIDs + 
           " AND vendor_id=" + vendIDs + 
           " AND dozen=" + selectedItmDzn + 
           " AND quantity=" + selectedItmQty + 
           " AND total_price=" + selectedItmTotPrc + "",
     con);
  cmd.ExecuteNonQuery();
  </code></pre>
  
  <p>here is my conString </p>
  
  <p><code>SqlConnection con = new SqlConnection("Data Source=localhost;Initial Catalog=InvenotyBB;Integrated Security=SSPI")</code></p>
  
  <p>I have confirmed that the other verbs <em>(<strong>select</strong>, <strong>update</strong>, <strong>etc</strong>)</em> work, just not the specific command for <strong>delete</strong>.</p>