title: C# SQL INSERT wont be saved
body: <p>im trying to insert a new row in a mssql db, but it wont be saved. Could anyone tell me what the problem is? </p>
  
  <pre><code>string connectionString = Properties.Settings.Default.DonationsConnectionString;
  
  System.Data.SqlClient.SqlConnection sqlConnection1 =
  new System.Data.SqlClient.SqlConnection(connectionString);
  
  System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand();
  cmd.CommandType = System.Data.CommandType.Text;
  cmd.CommandText = "INSERT Donations (Name, Betrag) VALUES ('" + donator.Text + "', '" + betrag.Text + "')";
  cmd.Connection = sqlConnection1;
  
  sqlConnection1.Open();
  cmd.ExecuteNonQuery();
  sqlConnection1.Close();
  </code></pre>