Example #1
0
        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));
 }