private void Button5_Click(object sender, EventArgs e) { conn.ConnectionString = conString; cmd = conn.CreateCommand(); try { string query = "Delete from Member where Member_ID = " + SelectMember.memberID; cmd.CommandText = query; conn.Open(); //Execute the query cmd.ExecuteScalar(); MessageBox.Show("Member account deleted!", "Confirm", MessageBoxButtons.OK, MessageBoxIcon.Information); SelectMember s = new SelectMember(); s.Show(); this.Hide(); } catch (Exception ex) { string message = ex.Message.ToString(); string caption = "Error!"; MessageBox.Show(message, caption, MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { cmd.Dispose(); conn.Close(); } }
private void ComboBox1_SelectedIndexChanged(object sender, EventArgs e) { if (comboBox1.SelectedIndex == 0) { AdministratorPage ap = new AdministratorPage(); ap.Show(); this.Hide(); } else if (comboBox1.SelectedIndex == 1) { Librarian lb = new Librarian(); lb.Show(); this.Hide(); } else { SelectMember memberForm = new SelectMember(); memberForm.Show(); this.Hide(); } }