SQLCE Query having no effect?
I'm attempting to insert rows into an SQLCE database, and it's returning that 1 row is affected, there's no exception, and no syntax error in the query as far as I can see - but it's having no effect, when I look in the table from the Database Explorer.

If I run a query through VS, everything works fine. There's no connection problem as far as I can tell... what am I doing wrong here?

Here's the code, though it probably doesn't make a difference:

<!-- language: lang-vb -->

        Using conn As New SqlCeConnection(My.Settings.DietSafetyCheckerReportsConnectionString)
            conn.Open()

            Using cmd As SqlCeCommand = conn.CreateCommand()
                cmd.CommandText = "INSERT INTO Reports(PatientID, PreparedBy, PreparedFor, WeightInKilos, HeightInMeters, Age, PercentBodyFat, ElbowMeasurementInCentimeters, ReportDate, Gender) " &
                                  "VALUES(@pid, @pby, @pfor, @weight, @height, @age, @bodyfat, @elbow, @rdate, @gender);"

                cmd.Parameters.Add("@pid", SqlDbType.NVarChar, 100).Value = Me.PatientID
                cmd.Parameters.Add("@pby", SqlDbType.NVarChar, 100).Value = Me.PreparedBy
                cmd.Parameters.Add("@pfor", SqlDbType.NVarChar, 100).Value = Me.PreparedFor
                cmd.Parameters.Add("@weight", SqlDbType.Float).Value = Me.WeightInKilos
                cmd.Parameters.Add("@height", SqlDbType.Float).Value = Me.HeightInMeters
                cmd.Parameters.Add("@age", SqlDbType.TinyInt).Value = Me.Age
                cmd.Parameters.Add("@bodyfat", SqlDbType.Float, 100).Value = Me.PercentBodyFat
                cmd.Parameters.Add("@elbow", SqlDbType.TinyInt, 100).Value = Me.ElbowMeasurementInCentimeters
                cmd.Parameters.Add("@rdate", SqlDbType.DateTime).Value = Me.ReportDate
                cmd.Parameters.Add("@gender", SqlDbType.TinyInt, 100).Value = Me.Gender

                If cmd.ExecuteNonQuery() <> 1 Then Throw New ApplicationException("Failed to insert row into databse.")
            End Using

            conn.Close()
        End Using
SQLCE Query having no effect?
===

I'm attempting to insert rows into an SQLCE database, and it's returning that 1 row is affected, there's no exception, and no syntax error in the query as far as I can see - but it's having no effect, when I look in the table from the Database Explorer.

If I run a query through VS, everything works fine. There's no connection problem as far as I can tell... what am I doing wrong here?

Here's the code, though it probably doesn't make a difference:

<!-- language: lang-vb -->

        Using conn As New SqlCeConnection(My.Settings.DietSafetyCheckerReportsConnectionString)
            conn.Open()

            Using cmd As SqlCeCommand = conn.CreateCommand()
                cmd.CommandText = "INSERT INTO Reports(PatientID, PreparedBy, PreparedFor, WeightInKilos, HeightInMeters, Age, PercentBodyFat, ElbowMeasurementInCentimeters, ReportDate, Gender) " &
                                  "VALUES(@pid, @pby, @pfor, @weight, @height, @age, @bodyfat, @elbow, @rdate, @gender);"

                cmd.Parameters.Add("@pid", SqlDbType.NVarChar, 100).Value = Me.PatientID
                cmd.Parameters.Add("@pby", SqlDbType.NVarChar, 100).Value = Me.PreparedBy
                cmd.Parameters.Add("@pfor", SqlDbType.NVarChar, 100).Value = Me.PreparedFor
                cmd.Parameters.Add("@weight", SqlDbType.Float).Value = Me.WeightInKilos
                cmd.Parameters.Add("@height", SqlDbType.Float).Value = Me.HeightInMeters
                cmd.Parameters.Add("@age", SqlDbType.TinyInt).Value = Me.Age
                cmd.Parameters.Add("@bodyfat", SqlDbType.Float, 100).Value = Me.PercentBodyFat
                cmd.Parameters.Add("@elbow", SqlDbType.TinyInt, 100).Value = Me.ElbowMeasurementInCentimeters
                cmd.Parameters.Add("@rdate", SqlDbType.DateTime).Value = Me.ReportDate
                cmd.Parameters.Add("@gender", SqlDbType.TinyInt, 100).Value = Me.Gender

                If cmd.ExecuteNonQuery() <> 1 Then Throw New ApplicationException("Failed to insert row into databse.")
            End Using

            conn.Close()
        End Using