public void ShowSkills(string skillGroupID) { //get skillNames associated with provided SkillGroupID int sgid = Convert.ToInt32(skillGroupID); //do error checkng later 10/16/17 1:48 am if (sgid != 0) { DataSet dsSkillNamesById = DbMethods.GetSkillNamesBasedOnSkillGroupId(sgid); DataTable dtSkillNamesById = dsSkillNamesById.Tables[0]; gvShowSkillsBasedOnDdl.DataSource = dtSkillNamesById; gvShowSkillsBasedOnDdl.DataBind(); if (vlad.IsDataSetEmpty(dsSkillNamesById) == false) { Session["Skills"] = dsSkillNamesById;//for the GridView Paging } else { lblSearchError.Text = "no records to return :("; } } else {//get all skills DataSet dsAllSkillNames = DbMethods.GetSkillNamesOwnedByAllTuids(); DataTable dtAllSkillNames = dsAllSkillNames.Tables[0]; gvShowSkillsBasedOnDdl.DataSource = dtAllSkillNames; gvShowSkillsBasedOnDdl.DataBind(); if (vlad.IsDataSetEmpty(dsAllSkillNames) == false) { Session["Skills"] = dsAllSkillNames;//for the GridView Paging } else { lblSearchError.Text = "no records to return :("; } } }//end ShowSkills