private void btnRemove_Click(object sender, EventArgs e) { DialogResult dialogResult = MessageBox.Show("Are you Sure delete product details?", "Veryfy", MessageBoxButtons.YesNo); if (dialogResult == DialogResult.Yes) { Connector connector = new MYSQLDatabaseConnection(); /*catch update details into databaseColumn*/ DatabaseColumn DeleteDatabaseColumn = new DatabaseColumn(); DeleteDatabaseColumn.company_id = connector.SearchCompanyList(TempCompanyList, cmbCompanyName.SelectedItem.ToString()).company_id; DeleteDatabaseColumn.category_id = connector.SearchCategoryList(TempCategoryList, cmbCategoryName.SelectedItem.ToString()).category_id; DeleteDatabaseColumn.product_id = txtProductId.Text.ToString(); DeleteDatabaseColumn.product_name = txtProductName.Text; DeleteDatabaseColumn.sell_price = txtSellPrice.Text; DeleteDatabaseColumn.product_discount_price = txtDiscount.Text; DeleteDatabaseColumn.minimum_quantity = txtMinimumQuantity.Text; List <DatabaseColumn> TempListForDGV = new List <DatabaseColumn>(); TempListForDGV.Add(DeleteDatabaseColumn); connector.establish(); connector.SetData(DeleteDatabaseColumn); if (connector.RemoveProductDetails() == true) { CombineDataGridView combineDataGridView = new CombineDataGridView(); combineDataGridView.SetDataGridViewList(TempListForDGV, mDgv); MessageBox.Show("Delete compliete"); txtDiscount.Clear(); txtMinimumQuantity.Clear(); txtProductId.Clear(); txtProductName.Clear(); txtSellPrice.Clear(); } else { MessageBox.Show("Try again"); } } }