Tim Borowsky

Tim Borowsky

  • NA
  • 7
  • 4.6k

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

Aug 9 2014 6:21 PM
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?