Exemple #1
0
        public void Load()
        {
            var             command = DataStore.Connection.CreateCommand();
            SqlCeDataReader reader  = null;

            command.CommandText = "SELECT * FROM [reminders] ORDER BY [time]";

            reader = command.ExecuteReader();

            while (reader.Read())
            {
                Reminder rem = new Reminder(this);

                rem.Name      = reader.GetString("name");
                rem.Text      = reader.GetString("text");
                rem.Time      = reader.GetDateTime("time");
                rem.Frequency = reader.GetEnum <Frequency>("frequency");

                reminders.Add(rem);
                rem.Init();
            }

            reader.Dispose();
            command.Dispose();
        }