public ObservableCollection<DisplayResults> getPowerballRows() { powerballResults = new ObservableCollection<DisplayResults>(); using (var db = new SQLite.SQLiteConnection(app.dbPath)) { var query = db.Query<PowerBallSaved>("select * from PowerBallSaved"); foreach (var _res in query) { var res = new DisplayResults() { Id = _res.Id, Num1 = _res.num1, Num2 = _res.num2, Num3 = _res.num3, Num4 = _res.num4, Num5 = _res.num5 }; powerballResults.Add(res); } } return powerballResults; }
public ObservableCollection<DisplayResults> getRows() { results = new ObservableCollection<DisplayResults>(); using (var db = new SQLite.SQLiteConnection(app.dbPath)) { var query = db.Query<LottoSaved>("select * from LottoSaved"); foreach (var _results in query) { var res = new DisplayResults() { Id = _results.Id, Num1 = _results.num1, Num2 = _results.num2, Num3 = _results.num3, Num4 = _results.num4, Num5 = _results.num5, Num6 = _results.num6 }; results.Add(res); } } return results; }