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(); }