private void Dgv_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
string colName = dgv.Columns[e.ColumnIndex].Name;
if (colName == "Ubah")
{
tmbPelanggan frm = new tmbPelanggan(this);
frm.lblJudul.Text = "Ubah Data Pelanggan";
frm.btnSimpan.Visible = false;
frm.lblId.Text = dgv[0, e.RowIndex].Value.ToString();
frm.txtKode.Text = dgv[1, e.RowIndex].Value.ToString();
frm.txtNama.Text = dgv[2, e.RowIndex].Value.ToString();
frm.cmbGender.Text = dgv[3, e.RowIndex].Value.ToString();
frm.txtTelp.Text = dgv[3, e.RowIndex].Value.ToString();
frm.txtAlamat.Text = dgv[4, e.RowIndex].Value.ToString();
frm.ShowDialog();
}
else if (colName == "Hapus")
{
if (MessageBox.Show("Apakah Anda yakin ingin menghapus data ini?", "", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
cn.Open();
cm = new SqlCommand("delete from Pelanggan where id ='" + dgv[0, e.RowIndex].Value.ToString() + "'", cn);
cm.ExecuteNonQuery();
cn.Close();
load();
lblSukses.Visible = false;
lblUbah.Visible = false;
lblHapus.Visible = true;
}
}
}
private void BtnTambah_Click(object sender, EventArgs e)
{
tmbPelanggan frm = new tmbPelanggan(this);
frm.btnUbah.Visible = false;
frm.ShowDialog();
}
