Here is the code i am using. The item in ListView AllEventsList in table Events does not gets deleted.
private async void DeleteSelected(object sender, RoutedEventArgs e)
{
try
{
var dbpath = Path.Combine(Windows.Storage.ApplicationData.Current.LocalFolder.Path, "data.db3");
using (var db = new SQLite.SQLiteConnection(dbpath))
{
db.Delete<Events>(AllEventsList.SelectedItem.ToString());//selected item
var d = from x in db.Table<Events>() select x;
AllEventsList.Items.Clear();
foreach (var sd in d)
{
AllEventsList.Items.Add(sd.EventName.ToString());
}
db.Dispose();
db.Close();
}
var line = new MessageDialog("Selected Item Deleted");
await line.ShowAsync();
}
catch
{
}
}
while this works:
db.DeleteAll<Events>();
Aucun commentaire:
Enregistrer un commentaire