public void FillDDLOfficeDept() { try { int?companyid = null; if ((Session["USERCOMPANYID"].ToString() != "") || (Session["USERCOMPANYID"] == null)) { companyid = Convert.ToInt32(Session["USERCOMPANYID"].ToString()); } DataTable dtOfficeDept = BLL_FBM_Report.GetOfficeDepartment(companyid); DDLOfficeDept.Items.Clear(); DDLOfficeDept.DataSource = dtOfficeDept; DDLOfficeDept.DataTextField = "VALUE"; DDLOfficeDept.DataValueField = "ID"; DDLOfficeDept.DataBind(); ListItem li = new ListItem("--SELECT ALL--", "0"); DDLOfficeDept.Items.Insert(0, li); FillDDLPrimaryCategory(); } catch (Exception ex) { } }