Skip to main content

Windows Phone 7 (Mango) Tutorial - 24 - Local Database Support, CRUD operation with Demo

n the last two chapters of the tutorial series, we discussed about the local database support in Windows Phone 7 (Mango). We learnt how to create a DataContext class from existing SQL CE database and also we learnt about the issues that arises once we add the class file in the project to build. We learnt the steps to resolve those issues too.

 

In this article, we are going to discuss about the CRUD operations that we can do using the DataContext class with a small application. We will learn how to create and delete a database, we will also learn how to insert or fetch records. After reading this tutorial you will also be able to do other operations like edit, search etc.


Read More...

Comments

Popular posts from this blog

Puzzle game for tablets and SmartPhones

Introduction

Puzzle is a simple game suitable for all ages. The goal of the game is to put the right pieces into correct shapes. Everyone has had a chance to play a puzzle game in real life but there are not that many puzzle games for mobiles. Nevertheless, this game is suitable as stand-alone game for children but it can be also used as a great marketing tool.

In this article, we would like to show you how to create this game for multiple mobile platforms using only one code. 

Background     

To overcome platform differences, we will use Moscrif SDK (available free for open source projects). This SDK comes with object-oriented JavaScript and open-source framework which is easy to learn. The SDK also contains publishing tools that generate native installation files. 

About the game 

Our game is made for Tablets and other devices, which run iOS and Android, with screen resolution larger than 600x900px. I have tested it on Amazon Kindle Fire, Galaxy Tab, Nook Color, iPad 2 and iPhone 4. 

In th…

Silverlight ‘Loading’ Spin Icon in XAML

When loading large object collections in Silverlight, there is enough of a time delay so that I need some kind of animated icon that indicates a 'loading' state. There were many such icons used when loading data via AJAX, which are basically animated Gif's. As Gif's aren't supported in Silverlight, I needed to create one. I decided therefore to create a design in Expression Design, and then animate it in Blend, with a little tidying up in VS2008.Im not sure how well it'll perform with large number of instances in a single control, but it does the trick for my needs.The code for my animated spinning logo is below. (Use the scaletransform in the grid to change the size)<Gridx:Name="LayoutRoot"Background="White"><Grid.RenderTransform><ScaleTransformx:Name="SpinnerScale"ScaleX="0.5"ScaleY="0.5"/></Grid.RenderTransform><CanvasRenderTransformOrigin="0.5,0.5"Width="120"…