private void BtnUpdate_Click(object sender, EventArgs e) { SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename='F:\C# FINAL ASSIGNMENT (GROUP 06)\DATABASE (Accounts).mdf';Integrated Security=True;Connect Timeout=30"); String update = "UPDATE Items SET Quantity = '" + CbQty.SelectedItem + "' WHERE Item_No = '" + TxtItemNo1.Text + "' "; SqlCommand cmd = new SqlCommand(update, con); try { con.Open(); cmd.ExecuteNonQuery(); MessageBox.Show("Quantity Updated successfully!", "CONGRATULATIONS!", MessageBoxButtons.OK, MessageBoxIcon.Information); CART c = new CART(); c.Show(); this.Hide(); } catch (Exception ex) { MessageBox.Show("Error detected :" + ex, "ERROR!", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { con.Close(); } }
private void Button8_Click(object sender, EventArgs e) { CART c = new CART(); c.Show(); this.Hide(); }