Click here to Skip to main content
15,888,288 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi,

How can i use delete in metro apps using sqlite wrapper.(http://sqlwinrt.codeplex.com/[^])
Though i am able to insert and select data using sqlite.
My code for delete is as follows:-


C#
try
{
    var db = new SQLite.Database("FavDB1.test"); // creates the database file in the local app folder
    if (db.Ready)
    {

        var stmt = db.PrepareStatement("CREATE TABLE IF NOT EXISTS Shows (ShowID INTEGER, Showname TEXT,showlink TEXT,image TEXT,classification TEXT,summary TEXT,network TEXT,airtime TEXT,airday TEXT)");
        if (stmt.Execute())
        {

            Expression.Blend.TvShowsData.TvShowsDataSource.TvShowsDataItem itm = Item as Expression.Blend.TvShowsData.TvShowsDataSource.TvShowsDataItem;
            
            Windows.UI.Xaml.Media.ImageSource image1 = itm.Image as Windows.UI.Xaml.Media.ImageSource;
            string imagePath = ((Windows.UI.Xaml.Media.Imaging.BitmapImage)(image1)).UriSource.ToString();
            int showID = GetShowID(imagePath);
            
           stmt = db.PrepareStatement("DELETE FROM Shows WHERE ShowID= " + showID.ToString());

            if (stmt.Execute())
            {
                //var fav = (from favShow in App.FavouriteShows
                //           where favShow.showid == showID
                //           select favShow).FirstOrDefault();

                //App.FavouriteShows.Remove(fav);
               
                App.FillFavShowsList(true);
                if (App.FavouriteShows.Count != 0)
                    App.ShowFavShowsCollection(App.FavouriteShows);
                else
                    App.ShowGroupedCollection();
            }

        }
    }
}
catch (ArgumentException ex)
{
   
}
Posted
Updated 28-Feb-12 23:02pm
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900