大家帮忙看个sql语句

douming 2006-06-29 11:09:10

string strsql = string.Empty
strsql = string.Format("INSERT INTO catOriginalEvent_Teacher (TermID, TermBatchNo, OriginalEventID, TeacherID) Values ('" + STermID.ToString() + "', " + TermBatchNo + ",'" + ID.ToString() + "', " + TeacherID + ")");
SqlCommand cmd = new SqlCommand(strsql, clsCATool.DBConn);

我调试的时候,发现TermBatchNo 的值是"2005-1",可写到数据库里却变成了"2004",怎么回事,其他的值都是对着的

...全文

98 7 打赏收藏转发到动态举报

写回复

用AI写文章

7 条回复

切换为时间正序

请发表友善的回复…

发表回复

gicjoe 2006-06-29

打赏
举报

不用string.Format
sql=INSERT INTO catOriginalEvent_Teacher (TermID, TermBatchNo, OriginalEventID, TeacherID) Values ('" + STermID.ToString() + "', " + TermBatchNo + ",'" + ID.ToString() + "', " + TeacherID + ")"

ugvihc 2006-06-29

打赏
举报

建议加上'',我也碰到过类似问题.

Muf 2006-06-29

打赏
举报

strsql = string.Format(
"INSERT INTO catOriginalEvent_Teacher (TermID, TermBatchNo, OriginalEventID, TeacherID) Values ('{0}', '{1}', '{2}', {3})",
STermID, TermBatchNo, ID, TeacherID );

yunxiao_2004 2006-06-29

打赏
举报

没有理解string.Format真正的长处
strsql = string.Format("INSERT INTO catOriginalEvent_Teacher (TermID, TermBatchNo, OriginalEventID, TeacherID) Values ({0}, '{1}',{2}, {3})"，STermID，TermBatchNo,ID ,TeacherID );
至于TermBatchNo 的值是"2005-1"为什么是2004，应该是你的TermBatchNo 的问题。