0
Answer

Help with updating SQL CE table on WinMo 6.5 with C#

Tim Borowsky

Tim Borowsky
10y
630
1
Hello,

I'm trying to update a SQL CE table on a Windows Mobile 6.5 device using C#.  It seems the following code looks correct, but I get a token error for against the strRoundInitials, stating that the token is invalid.

using (sqlCmd = new SqlCeCommand("UPDATE " + strDateTable + "SET [" + strRoundInitials +
"] = '" + txtDataEntry.Text + "'WHERE [" + strRoundShift + "] = '" + strBarCode + "'", sqlConn))

{        sqlCmd.ExecuteNonQuery();}

Any suggestions?
Next Recommended Forum