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?

9 Years
Discussion Span
Last Post by 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.


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

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.