private void btnCreateNew_Click(object sender, EventArgs e) { FormProduct frm = new FormProduct(this); frm.LoadCatagory(); frm.LoadBrand(); frm.LoadVendor(); frm.Show(); }
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e) { String colname = dataGridView1.Columns[e.ColumnIndex].Name; if (colname == "Edit") { FormProduct frm = new FormProduct(this); frm.btnSave.Enabled = false; frm.btnUpdate.Enabled = true; frm.textBoxBarcode.Enabled = false; frm.textBoxPcode.Enabled = false; LoadRecords(); frm.LoadBrand(); frm.LoadCatagory(); frm.LoadVendor(); frm.textBoxPcode.Text = dataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString(); frm.textBoxBarcode.Text = dataGridView1.Rows[e.RowIndex].Cells[2].Value.ToString(); frm.cboCatagory.Text = dataGridView1.Rows[e.RowIndex].Cells[3].Value.ToString(); frm.cboBrand.Text = dataGridView1.Rows[e.RowIndex].Cells[4].Value.ToString(); frm.textBoxPDescription.Text = dataGridView1.Rows[e.RowIndex].Cells[5].Value.ToString(); frm.textBoxQty.Text = dataGridView1.Rows[e.RowIndex].Cells[6].Value.ToString(); frm.textBoxBuying_price.Text = dataGridView1.Rows[e.RowIndex].Cells[7].Value.ToString(); frm.textBoxSelling_price.Text = dataGridView1.Rows[e.RowIndex].Cells[8].Value.ToString(); frm.textBoxDiscount.Text = dataGridView1.Rows[e.RowIndex].Cells[9].Value.ToString(); frm.textBoxRe_order.Text = dataGridView1.Rows[e.RowIndex].Cells[10].Value.ToString(); frm.cboVendor.Text = dataGridView1.Rows[e.RowIndex].Cells[11].Value.ToString(); frm.textBoxExpiry_date.CustomFormat = dataGridView1.Rows[e.RowIndex].Cells[12].Value.ToString(); frm.ShowDialog(); } else if (colname == "Delete") { if (MessageBox.Show("You want to remove this product?", "Remove", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { cn.Open(); cm = new SqlCommand("delete from tableProduct where pcode like '" + dataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString() + "'", cn); cm.ExecuteNonQuery(); cn.Close(); MessageBox.Show("Product removed sucessfully.", "Removed", MessageBoxButtons.OK, MessageBoxIcon.Information); LoadRecords(); } } }