public void refreshSections()
{
this.SectionList.Rows.Clear();
List <object>[] rs;
string[] columns = { "strSectCode", "strSectName", "strSectFacuCode" };
rs = dbConnect.Select("Select * from tblSection where boolSectIsDel = false;", columns);
for (int i = 0; i < rs[0].Count; i++)
{
// sect code(hidden) sect name adviser name
this.SectionList.Rows.Add(rs[0].ElementAt(i).ToString(), rs[1].ElementAt(i).ToString(), getAdvisorNameFromList(rs[2].ElementAt(i).ToString()));
}
//clear selection
SectionList.ClearSelection();
}
