private void btnUpdate_Click(object sender, EventArgs e)
 {
     if (txtUpdate.Text != null)
     {
         Product_DB.UpdateProduct(txtUpdate.Text, oldprodname);
         txtUpdate.Text = "";
     }
     product = Product_DB.GetAllProducts();
     productDataGridView.DataSource = product;
     this.Refresh();
 }
 private void btnDeactivate_Click(object sender, EventArgs e)
 {
     if (txtUpdate.Text != null)
     {
         string deactivate = ("inactive" + txtUpdate.Text);
         Product_DB.UpdateProduct(deactivate, oldprodname);
         txtUpdate.Text = "";
     }
     product = Product_DB.GetAllProducts();
     productDataGridView.DataSource = product;
     this.Refresh();
 }