title: SQL Insert Statement in C#
body: <pre><code>SqlConnection connection1 = new SqlConnection(Properties.Settings.Default.KalenderDBconnect);
  
  SqlCommand insertCommand = new SqlCommand(
       "INSERT into KalenderDB values ('" + tb_name + "','" + tb_Ort + "','" + tb_Event + "','" + tb_Notiz + "','" + teilgenommen + "','" + date + "')");
  
  connection1.Open();
  insertCommand.ExecuteNonQuery();
  connection1.Close();
  </code></pre>
  
  <p>Can somebody say, why the <code>insertCommand.ExecuteNonQuery()</code> doesn't work? I can't find the problem .</p>