/// <summary> /// When the client select the rating that wants to edit the not necessarily labels, tetxboxes and comboboxes are hiding /// from the form and then the neccesarily labels, tetxboxes and comboboxes are pop up. Then fills all the fields with /// the data of the selected rating. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void BtnSelect_Click(object sender, EventArgs e) { LblBusiness.Show(); LblDate.Show(); LblPerson.Show(); LblUsername.Show(); CmbBusiness.Show(); CmbUsername.Show(); BtnEdit.Show(); TbxPerson.Show(); DtpDate.Show(); LblSelect.Hide(); CmbSelect.Hide(); BtnSelect.Hide(); SelectedData = DCom.GetData(String.Format(SqlExec, CmbSelect.SelectedValue)); TbxPerson.Text = SelectedData.Rows[0]["Persons"].ToString(); CmbBusiness.DataSource = DCom.GetData("SELECT businesses.ID, CONCAT(businesses.Business_Name, ', ', location.Address_Name, ', ', location.Municipality) AS NAME FROM businesses, location WHERE businesses.Location_ID = location.ID"); CmbBusiness.DisplayMember = "NAME"; CmbBusiness.ValueMember = "ID"; CmbUsername.DataSource = DCom.GetData("SELECT * FROM users"); CmbUsername.DisplayMember = "Username"; CmbUsername.ValueMember = "Username"; CmbUsername.Text = SelectedData.Rows[0]["User"].ToString(); CmbBusiness.Text = SelectedData.Rows[0]["BusinessID"].ToString(); }