samedi 21 mars 2015

How to delete row in sqlite via ListView in C# for windows 8 app

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