vendredi 18 septembre 2015

How to delete the selected item from listview(sqlite database) in windows phone 8.1

I inserted text items to the database. When I click on remove button the selected item is not removed from list view.

 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();

        l.list1 = list_view.SelectedItem.ToString();       
        list_view.Items.Remove(l.list1);
        List<list> del = await con.QueryAsync<list>("delete from list where list1='" + list_view.SelectedItem + "'");
        if (del.Contains(list_view.SelectedItem))
        {
            list_view.Items.Remove(list_view.SelectedItem);
        }

(Here list1 is the column)

Aucun commentaire:

Enregistrer un commentaire