代码为
string sql=string.format("update teacher set sex={0} where teachername={1}",sex,cb.Text);
sqlcommand command=new sqlcommand(sql,connection);
int result=command.ExecuteNonQuery();(提示这句等号附近有错误,不过不知道什么错误)
...
请赐教,囧
rveræå¡ï¼ç¨åæ°æ®åºçæ°æ®æ件è¦çæè¿ä¸ªæ°å»ºçæ°æ®åºæ件ï¼éå¯sql serveræå¡ãæå¼ä¼ä¸ç®¡çå¨ï¼è¯¥æ°æ®åºæ¾ç¤ºâç½®çâï¼å¨æ¥è¯¢åæå¨ä¸æ§è¡ä¸é¢çè¯å¥ï¼
USE MASTER
GO
SP_CONFIGURE 'ALLOW UPDATES',1 RECONFIGURE WITH OVERRIDE
GO
UPDATE SYSDATABASES SET STATUS =32768 WHERE NAME='ç½®ççæ°æ®åºå'
Go
sp_dboption 'ç½®ççæ°æ®åºå', 'single user', 'true'
Go
DBCC CHECKDB('ç½®ççæ°æ®åºå')
Go
update sysdatabases set status =28 where name='ç½®ççæ°æ®åºå'
Go
sp_configure 'allow updates', 0 reconfigure with override
Go
sp_dboption 'ç½®ççæ°æ®åºå', 'single user', 'false' Go
æ§è¡åæ°æ®åºæ¬èº«ä»ç¶æé®é¢ï¼ä¾æ§æ¾ç¤ºâè´¨çâãæ¤æ¶æ°å»ºä¸ä¸ªæ°çæ°æ®åºï¼è¿è¡DTS导åºå导ï¼ææé®é¢çæ°æ®åºä¸çæ°æ®å¯¼å ¥å°æ°çæ°æ®åºä¸ï¼æå¼æ°çæ°æ®åºï¼æ°æ®å ¨é¨æ¾åï¼
USE MASTER
GO
SP_CONFIGURE 'ALLOW UPDATES',1 RECONFIGURE WITH OVERRIDE
GO
UPDATE SYSDATABASES SET STATUS =32768 WHERE NAME='ç½®ççæ°æ®åºå'
Go
sp_dboption 'ç½®ççæ°æ®åºå', 'single user', 'true'
Go
DBCC CHECKDB('ç½®ççæ°æ®åºå')
Go
update sysdatabases set status =28 where name='ç½®ççæ°æ®åºå'
Go
sp_configure 'allow updates', 0 reconfigure with override
Go
sp_dboption 'ç½®ççæ°æ®åºå', 'single user', 'false' Go
æ§è¡åæ°æ®åºæ¬èº«ä»ç¶æé®é¢ï¼ä¾æ§æ¾ç¤ºâè´¨çâãæ¤æ¶æ°å»ºä¸ä¸ªæ°çæ°æ®åºï¼è¿è¡DTS导åºå导ï¼ææé®é¢çæ°æ®åºä¸çæ°æ®å¯¼å ¥å°æ°çæ°æ®åºä¸ï¼æå¼æ°çæ°æ®åºï¼æ°æ®å ¨é¨æ¾åï¼
温馨提示:答案为网友推荐,仅供参考
第1个回答 2011-02-27
你查一下数据表teacher中有没有sex和teachername这两个列,估计是其中一个或多个没在这个表中定义
第2个回答 2012-07-05
string sql=string.format("update teacher set sex='{0}'where teachername='{1}'",sex,cb.Text);
加上单引号
加上单引号