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

How to create cookies in ASP.NET?

A Cookie is a small amount of text that attached to the requet and response in between browser and the server. This small amount of text can be read by the application whenever user browse the it. Please note that cookie is not a good medium to store the confidential data as it is stored into the user browser.
Read More...

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…