title: C# how to insert data to mysql using C#?
body: <p>Im very new on C#</p>
  
  <p>I Only create 1 Form that Can insert Data to Mysql Database. My code not have Error, but data cant enter the Database. I m so confused.</p>
  
  <p>this my code
  <strong>Koneksi.cs</strong></p>
  
  <pre><code>using System;
  using System.Data;
  using MySql.Data.MySqlClient;
  using System.Drawing;
  using System.Windows.Forms;
  
  
  
  namespace timbangan
  {
      public class Koneksi
      {
          public MySqlConnection konek;
  
          //string konfigKoneksi = "server=localhost; database=timbangan; uid=root; pwd=";
          string konfigKoneksi = "Server=localhost;Database=timbangan;Uid=root;Pwd=";
  
          public void bukaKoneksi()
          {
              konek = new MySqlConnection(konfigKoneksi);
              konek.Open();
  
              var temp = konek.State.ToString();
  
              if (temp == "Open")
              {
  
                  MessageBox.Show(@"Connection working.");
  
              }
              else {
  
                  MessageBox.Show(@"Please check connection string");
  
  
  
              }
          }
          public void tutupKoneksi()
          {
              konek = new MySqlConnection(konfigKoneksi);
              konek.Close();
          }
  
  
      }//end of koneksi
  }//end namespace
  </code></pre>
  
  <p><strong>Isidata.cs</strong> File</p>
  
  <pre><code>using System;
  using System.Data;
  using MySql.Data.MySqlClient;
  using System.Windows.Forms;
  
  namespace timbangan
  {
      public class Isidata
      {
          MySqlDataAdapter adapter;
          MySqlCommand komand;
          Koneksi classKoneksi;
          DataTable tabel;
          string sql = "";
  
          public DataTable tambahData(string berat_filter, string qty, string nama_barang, string dari, string shift)
          {
              classKoneksi = new Koneksi();
  
              sql = "insert into tb_timbang(BERAT_FILTER,QTY,NAMA_BARANG,DARI,SHIFT) values (" + berat_filter + ",'" + qty + "','" + nama_barang + "','" + dari + "','" + shift + "')";
              //MessageBox.Show(sql);
              tabel = new DataTable();
  
  
              try
              {
                  classKoneksi.bukaKoneksi();
                  komand = new MySqlCommand(sql);
                  adapter = new MySqlDataAdapter(sql, classKoneksi.konek);
                  adapter.Fill(tabel);
              }
  
              catch (Exception)
              {
                  MessageBox.Show("error");
              }
              return tabel;
          }
  
  
      }//end of issdata
  }//end of timbangan
  </code></pre>
  
  <p><strong>Form1.cs</strong> File</p>
  
  <pre><code>using System;
  using System.Drawing;
  using System.Windows.Forms;
  using System.Data;
  
  namespace timbangan
  {
      public partial class Form1 : Form
      {
          public DataTable tabel;
          public string status = "";
          public string berat_filter, qty, nama_barang, dari, shift;
  
  
          public Form1()
          {
              InitializeComponent();
          }
  
  
          private void button1_Click(object sender, EventArgs e)
          {
              Isidata isi = new Isidata();
              tabel = isi.tambahData(tbBerat.Text, tbQty.Text, tbNama.Text, tbDari.Text, tbShift.Text);
              MessageBox.Show("Berhasil");
  
          }
  
  
      }
  }
  </code></pre>
  
  <p>Can Anyone Help me to Fix this? or Advice me to have more short code to Insert data?</p>
  
  <p>Thanks in advance</p>