private void button3_Click(object sender, EventArgs e) { try { con_db deleteone = new con_db(); string sql = ""; ListViewItem record = listView1.SelectedItems[0]; if (record.SubItems[7].Text == "Root user") { MessageBox.Show("You cannot remove this user from the system"); } else if (record.SubItems[7].Text == "Admin") { if (DialogResult.Yes == MessageBox.Show("Are you sure u want to delete this user?", "Confirm deletion", MessageBoxButtons.YesNo)) { sql = "DELETE FROM admns WHERE usrname='" + record.SubItems[1].Text + "'"; if (deleteone.Delete(sql)) { MessageBox.Show("user deleted success!!"); Refreshall(); } } } else if (record.SubItems[7].Text == "G/User") { if (DialogResult.Yes == MessageBox.Show("Are you sure u want to delete this user?", "Confirm deletion", MessageBoxButtons.YesNo)) { sql = "DELETE FROM gnrlusers WHERE usrname='" + record.SubItems[1].Text + "'"; if (deleteone.Delete(sql)) { MessageBox.Show("user deleted success!!"); Refreshall(); } } } else { MessageBox.Show("User not found"); } } catch (Exception) { MessageBox.Show("Cant perform operation. Make sure you have selected a specific user!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void button3_Click(object sender, EventArgs e) { try { con_db deleteone = new con_db(); string sql = ""; ListViewItem record = listView1.SelectedItems[0]; sql = "DELETE FROM stations WHERE st_code='" + record.SubItems[2].Text + "'"; if (DialogResult.Yes == MessageBox.Show("Are you sure you want to delete this station?", "Confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Question)) { if (deleteone.Delete(sql)) { MessageBox.Show("user deleted success!!"); } } else { MessageBox.Show("User not found"); } } catch (Exception) { MessageBox.Show("Cant perform operation. Make sure you have selected a specific user!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }