title: ExecuteNonQuery Incorrect syntax near ','
body: <pre><code>sqlCommand1 = new SqlCommand("INSERT INTO dbo.Orders(Title,Seats,Payment,DateNTime)"+
              "VALUES ('"+ movieName+"',"+numTickets+",'"+creditCardType+"',"+DateTime.Now+")", sqlConnection1);
          sqlCommand1.Connection.Open();
          sqlCommand1.ExecuteNonQuery();
          sqlCommand1.Connection.Close();
  </code></pre>
  
  <p>No idea what's wrong with this piece of code. Title and Payment are stored as nvarchar types, Seats as an int and DateNTime as DateTime.
  Can someone help me with this?</p>
  
  <p>Thanks in advance</p>