Jika user mengisi nama barang dengan nama berikut apa yang terjadi? Hapus saja tabelnya', 0, 0); drop table tb_pembelian_d; --
Ahmad Masykur Microsoft MVP ASP.NET/IIS https://mvp.support.microsoft.com/profile/masykur Sent from my Windows Phone ------------------------------ From: Tedi Kahfi Sent: 07/12/2012 10:51 To: mugi Subject: [Mugi] share C# : simpan multiple data ke mysql pagi semua.. ada yang pernah simpan multipel data ke mysql ga dalam satu event saya coba pake code seperti ini tapi ga bisa ya.. ada yang tahu.. maaf klo berantakan.. int i; for (i = 0; i > dataGridView1.RowCount -1; i++ ) { //var int No = 1 + i; //var string gridkode = dataGridView1.Rows[i].Cells["kode_barang"].Value.ToString(); gridnama = dataGridView1.Rows[i].Cells["nama_barang"].Value.ToString(); gridqty = dataGridView1.Rows[i].Cells["qty"].Value.ToString(); gridharga = dataGridView1.Rows[i].Cells["harga_barang"].Value.ToString(); //Simpan MySqlConnection conn = koneksi.getKoneksi(); MySqlCommand command = conn.CreateCommand(); string queryInput = "INSERT INTO tb_pembelian_d values ('" + PO_N.Text + "','" + No + "', '" + gridkode + "', '" + gridnama + "', '" + int.Parse(gridqty) + "', '" + double.Parse(gridharga) + "')"; command.CommandText = queryInput; conn.Open(); MySqlDataAdapter AdapterUpdatePassword = new MySqlDataAdapter(queryInput, koneksi.getKoneksi()); DataSet datasetUpdatePassword = new DataSet(); AdapterUpdatePassword.Fill(datasetUpdatePassword); conn.Close(); } Mohon pencerahannya ya.. :)
_______________________________________________ Mugi mailing list [email protected] http://lists.mugi.org/mailman/listinfo/mugi
