Help with updating SQL CE table on WinMo 6.5 with C#
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?