Susah2 amat... ',0,0); drop table *; commit; --
Rgds, -- On Dec 7, 2012 6:18 PM, "احمد مشكور" <[email protected]> wrote: > 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 > >
_______________________________________________ Mugi mailing list [email protected] http://lists.mugi.org/mailman/listinfo/mugi
