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
}
}
