private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e) { string colName = dataGridView1.Columns[e.ColumnIndex].Name; if (colName == "Edit") { frmProduct frm = new frmProduct(this); frm.btnSave.Enabled = false; frm.btnUpdate.Enabled = true; frm.txtPcode.Text = dataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString(); frm.txtBarcode.Text = dataGridView1.Rows[e.RowIndex].Cells[2].Value.ToString(); frm.txtPdesc.Text = dataGridView1.Rows[e.RowIndex].Cells[3].Value.ToString(); frm.txtPrice.Text = dataGridView1.Rows[e.RowIndex].Cells[6].Value.ToString(); frm.cboBrand.Text = dataGridView1.Rows[e.RowIndex].Cells[4].Value.ToString(); frm.cboCategory.Text = dataGridView1.Rows[e.RowIndex].Cells[5].Value.ToString(); frm.ShowDialog(); } else { if (MessageBox.Show("Are you sure you want to delete this record?", "Delete Record", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { cn.Open(); cm = new SQLiteCommand("delete from tblproduct where pcode like '" + dataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString() + "'", cn); cm.ExecuteNonQuery(); cn.Close(); LoadRecords(); } } }
private void pictureBox2_Click(object sender, EventArgs e) { frmProduct frm = new frmProduct(this); frm.btnSave.Enabled = true; frm.btnUpdate.Enabled = false; frm.LoadBrand(); frm.LoadCategory(); frm.ShowDialog(); }