public EvidenceReport(UserSkills curUS, UserEvidence curUE) { InitializeComponent(); MySqlConnection conn = ConnectionSingleton.Instance.getSharedConnection(); string sql = "SELECT skills.name FROM skills"; MySqlDataAdapter dataAdapter = new MySqlDataAdapter(sql, conn); DataSet ds = new DataSet(); conn.Open(); dataAdapter.Fill(ds, "Skills_Table"); conn.Close(); foreach (DataRow row in ds.Tables[0].Rows) { this.comboBoxSkill.Items.Add(row[0]); } conn = ConnectionSingleton.Instance.getSharedConnection(); sql = "SELECT users.firstname, users.lastname FROM users"; dataAdapter = new MySqlDataAdapter(sql, conn); ds = new DataSet(); conn.Open(); dataAdapter.Fill(ds, "Users_Table"); conn.Close(); foreach (DataRow row in ds.Tables[0].Rows) { this.comboBoxUser.Items.Add(row[0] + " " + row[1]); } this.labelAuthro.Text = $@"Author: {DataController.GetDiscreteUser().Firstname} {DataController.GetDiscreteUser().Lastname}"; this.labelCreated.Text = $@"Created At: {DateTime.Now.ToString()}"; this.labelLastEdit.Text = $@"Last Edit At: {DateTime.Now.ToString()}"; this.buttonAddEvidence.Visible = true; this.buttonSave.Visible = false; if (curUS != null) { us = curUS; } if (curUE != null) { ue = curUE; } }