I am now writting new app and use the VB class below to connect the db but I am getting Path error. Could anyone help. I am using the emulater now not on the device.
Code:
Imports System.Data.SqlServerCe

Public Class ShiftManagerProDB
    Public Shared Function GetConnected() As SqlCeConnection
        Return New SqlCeConnection(GetConnectionString)
    End Function

    Public Shared Function GetConnectionString() As String
        GetConnectionString = "Data Source= C:\My Documents\ShiftManagerPro.sdf;persist security info=False;"
    End Function
End Class
Moreover I generated strongly typed dataset using two tables, I am not able to drag the table onto the datagrid because the dataset shows both tables and when I drag one it shows on data from that one. Can I get help on how to go about it. thanks