private void EditDataBtn_Click(object sender, EventArgs e) { NumberPhoneText.ReadOnly = false; EmailTextBox.ReadOnly = false; NicknameText.ReadOnly = false; EditChangeBtn.Show(); }
private void EditChangeBtn_Click(object sender, EventArgs e) { string connStr = "server=localhost;user=root;database=estateagency;password=root"; MySqlConnection conn = new MySqlConnection(connStr); conn.Open(); string sql = $"UPDATE profile " + $"SET nickname = '{NicknameText.Text}' " + $"WHERE id_profile = {id_profile.ToString()};"; MySqlCommand command = new MySqlCommand(sql, conn); command.ExecuteScalar(); sql = $"UPDATE profile " + $"SET email = '{EmailTextBox.Text}' " + $"WHERE id_profile = {id_profile.ToString()};"; command = new MySqlCommand(sql, conn); command.ExecuteScalar(); sql = $"UPDATE profile " + $"SET phoneNumber = '{NumberPhoneText.Text}' " + $"WHERE id_profile = {id_profile.ToString()};"; command = new MySqlCommand(sql, conn); command.ExecuteScalar(); conn.Close(); NumberPhoneText.ReadOnly = true; EmailTextBox.ReadOnly = true; NicknameText.ReadOnly = true; EditChangeBtn.Hide(); }