Member Avatar for 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?

  • 2 Contributors
  • 4 Replies
  • 83 Views
  • 5 Days Discussion Span
  • Latest Post Latest Post by juliusceasar
Member Avatar for 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.

Member Avatar for kvprajapati

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.