private async void b1_Click(object sender, RoutedEventArgs e) { var path = ApplicationData.Current.LocalFolder.Path + "/myDb1.DB"; var con = new SQLiteAsyncConnection(path); Favourite myfav = new Favourite(); List <Favourite> allfavs = new List <Favourite>(); allfavs = await con.QueryAsync <Favourite>("select placeName from Favourite "); string r = ""; foreach (Favourite f in allfavs) { r += f.placeName; } restb.Text = r; //Frame.Navigate(typeof(Favouriteslist)); }
private async void b1_Click(object sender, RoutedEventArgs e) { var path = ApplicationData.Current.LocalFolder.Path + "/myDb1.DB"; var con = new SQLiteAsyncConnection(path); Favourite myfav = new Favourite(); List<Favourite> allfavs = new List<Favourite>(); allfavs=await con.QueryAsync<Favourite>("select placeName from Favourite "); string r = ""; foreach(Favourite f in allfavs) { r += f.placeName; } restb.Text = r; //Frame.Navigate(typeof(Favouriteslist)); }