I get this error when i run the query below. (with the pointer at cmd.ExecuteNonQuery).
Im not sure what data conversion its trying to do as im using simple data types...
can someone give me any pointers/advice as what to change or what the problem is.
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim conn As New SqlCeConnection("Data Source=\My Documents\ECADDY.sdf")
Dim sql As String = "INSERT tblPlayer (FirstName,PlayerNo) VALUES ('Joe','1')"
Dim cmd As New SqlCeCommand(sql, conn)
cmd.ExecuteNonQuery() ' Execute the command here
'and then read
Dim myreader As SqlCeDataReader
myreader = cmd.ExecuteReader