Help with PocketPC App and Database Needed

[juliusceasar]

I am designing a pocketpc app to manage service delivery at restaurants.

I have designed the interface of the app and defined the schema of the database using a Microsoft SQL Server Compact 3.5 database file.

I cannot figure out how to interact with this file tho, I'm using vb and familiar with using recordsets and access databases but I have been out of the loop for a few years.

Can anyone point me in the direction of a good tutorial or help me understand what I'm missing?

[kvprajapati]

juliusceasar,

Read this http://www.codeproject.com/KB/database/SqlCompactCoptUtility.aspx
and
http://www.databasejournal.com/features/mssql/article.php/3694086/Programming-SQL-Server-2005-Compact-Edition-with-ADO.htm

[juliusceasar]

Thanks I am basically on my way, one issue tho, I cant get it to find my database,

Dim myConn As New System.Data.SqlClient.SqlConnection("Data Source=RSDS.sdf")

The database file is in the project directory but i am getting an error basically saying invalid path.

I do believe I understand how to interact with it and will be marking it as solved very shortly.

[kvprajapati]

Use classes of System.Data.SqlServerCe namespace. (Add reference for that library - System.Data.SqlServerCe.dll)

[juliusceasar]

Thanks