Can I update live tiles in Mango using local data?

Question

I have a Mango WP7.5 application that uses a local SqlCe database. I would like to add a LiveTile update that displays information received from the local database, depending on the current day and month.

All the samples I found update the background by loading remote images from the servers, but I just need to query the local database and show the line in my fragment.

Can I do it? How?

Answer 1

Yes, you can. You must

• create an image containing your textual information.
• save this image in isolated storage and
• access it through the isostore URI.

Here is the code showing how to do this (it updates the Application Tile):

 // set properties of the Application Tile private void button1_Click(object sender, RoutedEventArgs e) { // Application Tile is always the first Tile, even if it is not pinned to Start ShellTile TileToFind = ShellTile.ActiveTiles.First(); // Application Tile should always be found if (TileToFind != null) { // create bitmap to write text to WriteableBitmap wbmp = new WriteableBitmap(173, 173); TextBlock text = new TextBlock() { FontSize = (double)Resources["PhoneFontSizeExtraLarge"], Foreground = new SolidColorBrush(Colors.White) }; // your text from database goes here: text.Text = "Hello\nWorld"; wbmp.Render(text, new TranslateTransform() { Y = 20 }); wbmp.Invalidate(); // save image to isolated storage using (IsolatedStorageFile isf = IsolatedStorageFile.GetUserStoreForApplication()) { // use of "/Shared/ShellContent/" folder is mandatory! using (IsolatedStorageFileStream imageStream = new IsolatedStorageFileStream("/Shared/ShellContent/MyImage.jpg", System.IO.FileMode.Create, isf)) { wbmp.SaveJpeg(imageStream, wbmp.PixelWidth, wbmp.PixelHeight, 0, 100); } } StandardTileData NewTileData = new StandardTileData { Title = "Title", // reference saved image via isostore URI BackgroundImage = new Uri("isostore:/Shared/ShellContent/MyImage.jpg", UriKind.Absolute), }; // update the Application Tile TileToFind.Update(NewTileData); } }