title: Why I can't insert my data ? c# winform
body: <p>I wanna ask about this ..
  <br/>My query is not successful but i didn't see anything wrong here<br/>
  here's my Code :<br/></p>
  
  <pre><code>        private void save_btn_Click(object sender, EventArgs e)
          {
              MySqlConnection con = new MySqlConnection("server=127.0.0.1;database=project;Uid=root;Pwd=admin");
              MySqlCommand job;
              string id_pembayaran = count_id("payment");
              string order_id = String.Concat("ORD", id_pembayaran);
  
              for (int i = 0; i &lt; List_Pembelian.Rows.Count; i++){
              job = new MySqlCommand("INSERT INTO payment VALUES(@id,@ordid,@userid,@nama,@jlh,@total)", con);
              job.Parameters.AddWithValue("@id",count_id("payment"));
              job.Parameters.AddWithValue("@ordid", order_id);
              job.Parameters.AddWithValue("@userid", User_Validation_Field.Text);
              job.Parameters.AddWithValue("@nama", List_Pembelian.Rows[i].Cells[0].Value.ToString());
              job.Parameters.AddWithValue("@jlh", List_Pembelian.Rows[i].Cells[1].Value.ToString());
              job.Parameters.AddWithValue("@total",List_Pembelian.Rows[i].Cells[3].Value.ToString());
              con.Open();
              try
              {
                  job.ExecuteNonQuery();
                  int a = job.ExecuteNonQuery();
                  MessageBox.Show(a.ToString());
                  MessageBox.Show("SUKSES");
              }
              catch (Exception ex)
              {
                  MessageBox.Show(ex.Message);
  
              }
              finally
              {
                  con.Close();
              }
            }
          }
  </code></pre>
  
  <p>Did I do any mistake in my code? If yes please tell me x.x </p>