private void BindBuildingUnitNumbers(int BuildingNo) { try { DataTable dt = ProjectLeadOccupantsData.GetBuildingUnitNumbers(BuildingNo); if (dt.Rows.Count > 0) { ddlUnitNumber.Items.Clear(); ddlUnitNumber.DataSource = dt; ddlUnitNumber.DataValueField = "LeadUnitID"; ddlUnitNumber.DataTextField = "Unit"; ddlUnitNumber.DataBind(); ddlUnitNumber.Items.Insert(0, new ListItem("Select", "NA")); } else { ddlUnitNumber.Items.Clear(); ddlUnitNumber.Items.Insert(0, new ListItem("No Units Found", "NA")); } } catch (Exception ex) { LogError(Pagename, "BindBuildingNumbers", "", ex.Message); } }