2
Answers

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

Tim Borowsky

Tim Borowsky

10y
578
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?

Answers (2)