public void FillControls() { DataSet allSGNs = DbMethods.GetAllSkillGroupNames();//get dataSet from DB if (vlad.IsDataSetEmpty(allSGNs) == true) { lblSearchError.Text = "your DataSet is EMPTY."; } else { lblSearchError.Text = " "; int numberOfRows = allSGNs.Tables[0].Rows.Count; DataTable SkillGroup = allSGNs.Tables[0]; DataRow addingNewRow = SkillGroup.NewRow(); addingNewRow["SkillGroupID"] = "0";//"all Skill Groups has a value of 0 so I know to SELECT ALL when doing a search addingNewRow["SkillGroupName"] = "All Skill Groups"; addingNewRow["LastUpdateDate"] = "2017-10-15 22:15:00.000"; addingNewRow["LastUpdateUser"] = "******"; //add all skills option to dataTable SkillGroup.Rows.Add(addingNewRow); SkillGroup.AcceptChanges(); ddlSkillGroup.DataSource = SkillGroup; ddlSkillGroup.DataTextField = "SkillGroupName"; //shows the name each skill group ddlSkillGroup.DataValueField = "SkillGroupID"; //each name has a value of it's ID ddlSkillGroup.DataBind(); Session.Add("SkillGroup", SkillGroup);//adding skillGroup table to session obj } }