public void BindEvaluationLocation(int EvaluationID) { DataTable dt = BLL_Crew_Evaluation.Get_EvaluationLocation(EvaluationID); if (dt.Rows.Count > 0) { BLL_Infra_UserCredentials objUCred = new BLL_Infra_UserCredentials(); DataTable dtUser = objUCred.Get_UserList(Convert.ToInt32(Session["USERCOMPANYID"])); dtUser = dtUser.Select("User_Type='OFFICE USER'").CopyToDataTable(); ddlEvaluator.DataSource = dtUser; ddlEvaluator.DataTextField = "USERNAME"; ddlEvaluator.DataValueField = "USERID"; ddlEvaluator.DataBind(); ListItem lst = new ListItem(); lst.Text = "--SELECT--"; lst.Value = "-1"; ddlEvaluator.Items.Insert(0, lst); ddlEvaluator.Visible = true; txtNotify.Visible = true; txtNotify.Text = ""; lblEvaluator.Visible = true; lblNotify.Visible = true; lblDays.Visible = true; lblnman.Visible = true; lbleman.Visible = true; chkOffice.Checked = true; ddlEvaluator.SelectedValue = dt.Rows[0]["EvaluatorID"].ToString(); txtNotify.Text = dt.Rows[0][1].ToString(); } else { chkOffice.Checked = false; ddlEvaluator.Visible = false; txtNotify.Visible = false; txtNotify.Text = ""; lblEvaluator.Visible = false; lblNotify.Visible = false; lblDays.Visible = false; lblnman.Visible = false; lbleman.Visible = false; } }