private void Button_Click_10(object sender, RoutedEventArgs e) { string user = sID.Content.ToString(); MySqlConnection connection = new MySqlConnection("server=localHost;uid=root;pwd=nakr1234;database=library;"); connection.Open(); MySqlDataReader mdr; string s = "select * from library.staff,library.address where staff.staff_id='" + user + "' AND staff.staff_id=address.s_id;"; MySqlCommand cmd = new MySqlCommand(s, connection); mdr = cmd.ExecuteReader(); updateAccount update = new updateAccount(mdr, "staff", user); connection.Close(); update.Owner = this; this.Hide(); update.Show(); }
private void updateMember_Click(object sender, RoutedEventArgs e) { string user = ""; if (memCheck.IsChecked == true) { user = Convert.ToString("member"); } else if (staffCheck.IsChecked == true) { user = Convert.ToString("staff"); } if (user == "") { MessageBox.Show("Please Select Member or Staff", "error"); } else { MySqlConnection connection = new MySqlConnection("server=localHost;uid=root;pwd=nakr1234;database=library;"); connection.Open(); MySqlDataReader mdr; string s = ""; if (user == "member") { s = "select * from library.members,library.address where members.mem_id='" + up_id.Text + "' AND members.mem_id=address.m_id;"; } else if (user == "staff") { s = "select * from library.staff,library.address where staff.staff_id='" + up_id.Text + "' AND staff.staff_id=address.s_id;"; } MySqlCommand cmd = new MySqlCommand(s, connection); mdr = cmd.ExecuteReader(); updateAccount update = new updateAccount(mdr, user, up_id.Text); connection.Close(); update.Owner = this; this.Hide(); update.Show(); } }