public static void loadEvents() { events.Clear(); if (!opened) { return; } string sql = "SELECT rowid, d,m,y, since,length,data FROM events"; var cmd = new SQLiteCommand(sql, db); SQLiteDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { var item = new EventRecord(); item.id = Convert.ToInt32(reader["rowid"]); item.since = Convert.ToSingle(reader["since"]); item.length = Convert.ToSingle(reader["length"]); item.data = reader["data"].ToString(); item.d = Convert.ToInt32(reader["d"]); item.m = Convert.ToInt32(reader["m"]); item.y = Convert.ToInt32(reader["y"]); allEvents[item.id] = item; } }