I have been hearing so much about the development of pocket PC applications and how useful they actually are that I decided to develop a pocket PC Application for myself just to see what the difference is between pocket pc applications and desktop applications.

In the beginning I faced a couple of issues, the main problem being how to connect a pocket PC application to a database. Since I could not install the database on a pocket PC and populate it with all my records, I tried to find a way to integrate my pocket PC application with the database. For this purpose I worked on several logics and also tried to find out solutions on the internet but it did not help much except for providing me with some bits and pieces of codes. I could not find any solution which could help me to connect a pocket PC Application to my database. There were some sites I encountered which explained this process but the code was difficult to understand for beginners. I did not want to use that code because I always try to present solutions in a way which is useful for newbie(s).

Finally I came up with an idea to connect our pocket pc application to a database and have discussed it below.

Prepare Yourself For Pocket PC Applications

Introduction of Pocket PC Application

Before we start, I would like to tell you that a pocket PC is as expensive for me as it is for you guys, so we are going to use a pocket PC Emulator.

First let us concentrate on our main goal. Yes! Our main goal is to connect a pocket PC application to our database. For that we are going to develop the following two systems.

  1. A Pocket PC Application
  2. A Webservice that will connect our Pocket PC to the Database

As anyone who has ever built a smart client system knows, the code running on the smart client device is only part of the overall system. Much of the work actually occurs on the servers that support the system. Whether as databases or processing engines, servers must behave and communicate efficiently. Designing a successful smart client system requires an equal amount of attention to be paid to the server design as well as the smart client itself.

What is Emulator?

An emulator is a computer program or system that accepts the same inputs and produces the same outputs as a real Pocket PC device.

Fig. 1.0

Let's Start Developing The Application!

Step 1: Setting up the database.

The first thing you need to do is to create a database [table: FAQ].

Note: We are using Microsoft SQL server, but you can also use any other database

Note: You can use any database for this purpose, All you will need to configure is the connectionString.

Step 2: Creating a webservice.

Since we do not have direct communication with the server, we need to create a webservice in order to transfer data from the server to our pocket pc application.

Our webservice will fetch records from the database server, populate those records in the dataset and then return that dataset.

To create a webservice:

  1. Open Visual Studio .net 2005
  2. From the top menu, click File.
  3. lick New Web Site.
  4. Click Asp.net Web Service.



Note: You can name the webservice as you like, but keep in mind if you rename the webservice you will need to rename its references on my code as well.

There you go! After clicking OK on the dialog box shown above, VS .Net 2005 will create the webservice architecture for you, now all you will need to do is to write the code for it as per your need.

5. In the solution explorer double click the service.asmx page.

6. Create a webmethod and name it ReturnData().

[WebMethod]

public DataSet ReturnData()
{
String ConnectionString = "Data Source=Danish-it;Initial Catalog=KBFAQ;Persist Security Info=True;User ID=sa;Password=airforce";
SqlConnection SqlCon = new SqlConnection(ConnectionString);
SqlCon.Open();
SqlDataAdapter SqlDa = new SqlDataAdapter("Select keywords,answer,title from FAQ", SqlCon);
DataSet Ds = new DataSet();
SqlDa.Fill(Ds);
return Ds;
}

Note: Test your webservice by pressing the F5 key on your keyboard and then invoking you function.

Step 3: Creating pocket pc application.

Finally, we are on the last step of creating our pocket pc application.

Don't waste time, lets do it!

  1. Open Visual Studio .net 2005
  2. From the top menu, click File.
  3. Click New Project.
  4. Expand Visual C# node à Expand Smart Device node
  5. Click Pocket PC 2003 and select Device Application from the left pane.

Click OK on the dialog box like the one shown above and let VS .Net 2005 create a device application for you.

Once done, you will see a screen similar to the one below.

Now, add a webservice reference on the form.

You will the see the following screen.

Note: After creating the webservice make sure you create its virtual directory on IIS.

Type the following code in this event.

private void load_Click(object sender, EventArgs e)
{
PpcService.Service Ws = new PpcService.Service();
DataSet Ds = new DataSet("danish");
Ds = Ws.ReturnData();
myDataGrid.DataSource = Ds.Tables[0];
myDataGrid.Refresh();
}

Now on pressing the F5 key, VS .Net 2005 will ask you for the emulator settings.

Select Pocket PC 2003 Emulator and click deploy.

Think, done! Congratulations!