Best way to learn SQL Mobile?

I am an experienced web developer using PHP and MySql have experience with VB.

What is the best way for me to learn programming pocket pc's? Is using sql server mobile the best offline database to use as I will be using MySql Compact framework to connect direcly to our Linux server.

Any help is much appreciated as I can't seem to find any useful tutorials on quering an sql databse to update, insert, read or delete. I have created a datebase however, I just don't know how to use it.

Thanks in advance.

Mark

Hi Mark,

The SQL Mobile is ideal for offline scenarios. You can find SQL Mobile related resource on MDSN. I am providing the links below

SQL Mobile page on MSDN - http://msdn.microsoft.com/mobility/sqlmobile/default.aspx

SQL Mobile page from SQL Server home: http://www.microsoft.com/sql/editions/sqlmobile/default.mspx

SQL Mobile Books Online - http://msdn2.microsoft.com/en-us/library/ms173053.aspx

For advanced topics like replication with Microsoft SQL Server backend databases you can visit the following links

Connectivity with Microsoft SQL Server - http://www.microsoft.com/sql/editions/sqlmobile/connectivity-tools.mspx

HOL - http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnppcgen/html/med302_msdn_sql_mobile.asp

Manish

|||I'm working on somthing simular too. I want to connect to a mysql server on the web.
What do you use to connect to the mysql server?

The only thing I found for CF is MySQLDirect...

could you please let me know.
Dennis|||

I think I use the same one, it is made by Core Lab. The download link is below.

http://crlab.com/mysqlnet/download.html

Thanks for the links but I still cannot find a tutorial that demonstrates some simple insert, delete, update and select queries.

Mark

|||

Hi Mark,

Below is a specific link to IBuySpy Sample app available on MSDN

http://msdn2.microsoft.com/en-us/library/ms174006.aspx

IBuySpy Delivery 2005 Sample Application (SQL Server Mobile) - "When you install IBuySpy Delivery, you install modified versions of the IBuySpy database and Web application, and the code specific to the IBuySpy Delivery 2005 smart device application."

Hope this helps

Regards

Manish

|||

Thanks for all this help Manish, but I think your going to hate me now. I am starting to think that I am either stupid, a complete novice or more likley both.

The sample app you gave me is overly complicated and requires MS Server 2005 to be installed on my computer. I have no intension of doing this as I don't need it. I just need a sample of an extreamely simple application that has its own database and doesn't sync with anything, it is stand alone.

I simply need to know how to select data from the database and store it in an array(?) or something similar, and to send sql command to the database. I ask to store the results of a quey in an array because every example app I have found shows the data as a datagrid, which is ugly and not suitable for my current project.

ie. With PHP I would explain the above like so.

1. Connect to database using a connect string.

2. get results of a query using something like : $queryResults = getQueryResults("SELECT * FROM table")

3. Use a loop to read the $queryResults array. Read the date using : $queryResults[0]['name'] <-- this would give you the stored value in the first row and the in the field 'name'.

Can development for the pocket pc be this easy? I have developed app's for the Palm OS and naver had as much trouble as this. Why is it so overly complicated?

Thanks for your patience and help.

Mark