예제 #1
0
        private void cDToolStripMenuItem_Click(object sender, EventArgs e)
        {
            this.Hide();
            Formcd fc = new Formcd();

            if (fc.ShowDialog() == DialogResult.OK)
            {
                fc.ShowDialog();
            }
        }
예제 #2
0
        private void btnupdate_Click(object sender, EventArgs e)
        {
            MySqlCommand cmd = new MySqlCommand();

            cmd.Connection  = conn.myconnection();
            cmd.CommandText = "update cd set judul=@judul , jenis=@jenis , harga=@harga , keterangan=@keterangan , kode=@kode , kondisi=@kondisi,rak=@rak where id_cd=@id_cd ";
            cmd.Parameters.Add(new MySqlParameter("@judul", txtjudul.Text));
            cmd.Parameters.Add(new MySqlParameter("@jenis", cbjenis.Text));
            cmd.Parameters.Add(new MySqlParameter("@harga", txtharga.Text));
            cmd.Parameters.Add(new MySqlParameter("@keterangan", rbketerangan.Text));
            cmd.Parameters.Add(new MySqlParameter("@kode", txtkode.Text));
            cmd.Parameters.Add(new MySqlParameter("@kondisi", cbkondisi.Text));
            cmd.Parameters.Add(new MySqlParameter("@rak", txtrak.Text));
            cmd.Parameters.Add(new MySqlParameter("@id_cd", lblidcd.Text));
            cmd.ExecuteNonQuery();
            MessageBox.Show("berhasil");
            this.Hide();
            Formcd fc = new Formcd();

            if (fc.ShowDialog() == DialogResult.OK)
            {
                fc.ShowDialog();
            }
        }