Windows.Storage.ApplicationDataContainer data = Windows.Storage.ApplicationData.Current.LocalSettings; protected async override void OnNavigatedTo(NavigationEventArgs e) { if (data.Values["check"] != null) { this.Frame.Navigate(typeof(BlankPage1)); } if (data.Values["add"] != null) { list_view.Items.Add(data.Values["add"].ToString()); } if (data.Values["remove"] != null) { list_view.Items.Remove(data.Values["remove"]); } var dbpath = ApplicationData.Current.LocalFolder.Path + "/Mydb1.db"; var con = new SQLiteAsyncConnection(dbpath); await con.CreateTableAsync<list>(); } private void Button_Click(object sender, RoutedEventArgs e) { if(!mypop.IsOpen) { mypop.IsOpen = true; } } public async void Button_Click_1(object sender, RoutedEventArgs e) { var dbpath = ApplicationData.Current.LocalFolder.Path + "/Mydb1.db"; var con = new SQLiteAsyncConnection(dbpath); list l = new list(); data.Values["add"] = l.list1; l.list1 = text_input.Text.ToString(); await con.InsertAsync(l); await con.UpdateAllAsync(l.list1); data.Values["add"] = l.list1; list_view.Items.Add(data.Values["add"].ToString()); // list_view.Items.Add(text_input.Text.ToString()); mypop.IsOpen = false; } private void Button_Click_2(object sender, RoutedEventArgs e) { if(mypop.IsOpen) { mypop.IsOpen = false; } } private async void Button_Click_3(object sender, RoutedEventArgs e) { var dbpath = ApplicationData.Current.LocalFolder.Path + "/Mydb1.db"; var con = new SQLiteAsyncConnection(dbpath); list l = new list(); data.Values["remove"] = l.list1; l.list1 = list_view.SelectedItem.ToString(); list_view.Items.Remove(list_view.SelectedItem); List<list> mylist = await con.QueryAsync<list>("delete from list where list1='" + list_view.SelectedItem + "'"); mylist.Remove(l);
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)