c#更新语句

今天在c#中编程，出现了如下错误：
1“You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘13:17:53 where dish_name=’????????????’ and tableWZ=’??????-06” at line 1”
2我的SQL语句是“update tb_GuestFood set dish_sum = ” + fenshu2 + “,remark=”+remark.Text+”,datatime=” + dateTime + ” where dish_name=’” + dish + “’ and tableWZ=’” + table + “’”
3后来才发现string类型的字符段要加单引号，而int类型不需要加单引号。
我改写为如下，就可以了：
“update tb_GuestFood set dish_sum = ” + fenshu2 + “,remark=’”+remark.Text+”’,datatime=’” + dateTime + “’ where dish_name=’” + dish + “’ and tableWZ=’” + table + “’”