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
