1. Error nya apa om? 2. Mungkin lebih cepat tanggapannya (dan langsung manjur) kalau ditanyakan ke milis DotNetIndonesia.
Rgds, -- On Dec 7, 2012 10:52 AM, "Tedi Kahfi" <[email protected]> wrote: > 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
