Windows Mobile 6.5 Database Connection and Data Access

Now it is time to create a new table. It is exactly same as the SQL Server, we just right click on Tables under Databases and choose Create New Table.

We save our table as tbl1 and as you can see below we create two column named id and name. We mark id as primary key.

Now, to see our table's data we right click on tbl1 and choose show table data.

As you guess our table is empty because we did not add anything to table.We add our data in table save it.

Now it is time to acces database on our project and get the data. To do this first we have to add SqlServerCe to our project as a reference. We right click to our project and choose Add Reference. We choose System.Data.SqlServerCe from reference list as shown below. From now on Visual Studio will recognize SqlCe commands in our project.

We turn back to our application and drag a textbox and a buton to our form.Our scenario is that : We want to see on the textbox the name of the person whose id=1.So we expect to see on textbox "duygu".

We open applications code behind and add namespace System.Data.SqlServerCe.

After that we double click the buton and write these codes:

First 3 lines as you can guess we create our connection string. On 4th line we create our connection and 5th line we write the query for our scenario. 7th line we run our command cmd and get data from database and show it on textbox. As you can see all steps are same as SQL Server. Now we can run our project we pres F5 and see a screen like that:

We make settings as above and click deploy. It could take some time to run we should wait and finally we can see our application as shown below.

We just click the buton and see the result of our application.

Also we see the information we want.

We talked about connecting database and getting data from database on Mobile applications and we saw there is no difference between Sql Server and SQL Compact Edition on these steps.

You can download project source code.