the error occur after inserting 3 consecutive record. I add the record then after my 3rd time that error pop up. and another i cant view the record i made in my slq server mobile database in my pc. i used emulator. i can only see the record in the emulator database but after i stop the program the record also disappears.
what should be problem? tell me what should i do?
here's my code
HTML Code:Try ConnDatabase() cmdSData = CreateSQLConn.CreateCommand cmdSData.CommandText = "SELECT EANUPC, Itemdesc, RSP, [Count],itemcode FROM t_DATA" rstSData = cmdSData.ExecuteResultSet(ResultSetOptions.Updatable Or ResultSetOptions.Sensitive) Dim recSAVE As SqlCeUpdatableRecord = rstSData.CreateRecord() recSAVE.SetString(0, iBarcode) recSAVE.SetString(1, iItemDesc) recSAVE.SetDouble(2, iRSP) recSAVE.SetDouble(3, iCount) recSAVE.SetString(4, iItemcode) rstSData.Insert(recSAVE) Me.txtBarcode.Text = "" Me.txtRSP.Text = "" Me.txtCount.Text = "" Catch ex As Exception MessageBox.Show("Error: " & ex.Message) End Try
Thanks!![]()




Reply With Quote