// This returns items private List <NoteItem> SelectItems(string sql) { General.DB.ConnectSafe(); DataTable t = General.DB.Query(sql); if (t != null) { List <NoteItem> list = new List <NoteItem>(t.Count); foreach (DataTableRow r in t) { list.Add(NoteItem.FromDataRow(r)); } General.DB.Disconnect(); return(list); } else { // Failed! General.DB.Disconnect(); return(null); } }