protected void btnFinalShowVac_Click(object sender, EventArgs e) { if (DateTime.Parse(dateStart0.Text) > DateTime.Parse(DateEnd0.Text)) { lblInvalidInput.Visible = true; lblInvalidInput.Text = "End date can not be before start date."; //Empty DropDown DropDownListFinalResult.ClearSelection(); secondPhasePanel.Visible = false; } startedDate = dateStart0.Text.Trim(); endedDate = DateEnd0.Text.Trim(); VacancyRegistrationAndEvaluationManager manager = new VacancyRegistrationAndEvaluationManager(); TransactionResponse response = new TransactionResponse(); response = manager.getVacancyToGenerateReportByDateInterval(startedDate, endedDate, DbAccessConstants.spGetFinalPhaseVacancyByDateInterval); DataTable vacancyDetail = (DataTable)response.Data; DropDownListFinalResult.Items.Clear(); DropDownListFinalResult.Items.Add(new ListItem(" -- SELECT VACANCY --", "-1")); if (vacancyDetail != null && vacancyDetail.Rows.Count > 0) { clearmsgPanel(); secondPhasePanel.Visible = true; DropDownListFinalResult.DataSource = vacancyDetail; DropDownListFinalResult.DataValueField = "vacancy_detail_value"; DropDownListFinalResult.DataTextField = "vacancy_detail"; DropDownListFinalResult.DataBind(); } else { selectedVacancyPanel.Visible = false; msgPanel.Visible = true; InfoDIV.Visible = true; lblInformationMsg.Text = "There is no final phase result bewteen the selected date interval"; DropDownListFinalResult.ClearSelection(); } }