string UpTemp = "UPDATE template SET listcode=\'"+txtListCode+"\',bookcode=\'"+txtBookCode+ "\',linkcode=\'"+txtlinkCode+"\',onoff="+Request["onoff"].ToString()+" WHERE id="+Int32.Parse(Request["id"].ToString());里面的变量都是HTML代码..
onoff='"+Request["onoff"].ToString()+"'
上面的onoff是整型字段,,不能加'号吧
Have a try! string UpTemp = "UPDATE template SET listcode=\'"+txtListCode+"\',bookcode=\'"+txtBookCode+ "\',linkcode=\'"+txtlinkCode+"\',onoff="+Request["onoff"].ToString()+" WHERE id="+Request["id"].ToString(); or 输出如上的sql语句,看看是否正确
string UpTemp = "UPDATE template SET listcode=\'"+txtListCode+"\',bookcode=\'"+txtBookCode+ "\',linkcode=\'"+txtlinkCode+"\',onoff="+Request["onoff"].ToString()+" WHERE id="+Request["id"].ToString();
or
输出如上的sql语句,看看是否正确
试试,用ACCESS打开MDB文件,然后工具》数据库实用工具》压缩和修复看看。