问题描述
if(Request.QueryString["id"]==null){stringintoSQL="";intoSQL="webabout(nFile,nTitle,nHtmlText,ncode)values(";intoSQL+=""+myClass.replace(txtid.Text)+",";intoSQL+="'"+myClass.replace(txtitle.Text)+"',";intoSQL+="'"+txtContent.Text+"',";intoSQL+="'"+dbobj.getautoNum("webabout","nFile")+"')";dbobj.getcom("insertinto"+intoSQL);Page.RegisterStartupScript("alert",@"<scriptLANGUAGE=JavaScript>alert('添加成功');window.location='about.aspx';</script>");}else{stringupdateSQL="";updateSQL+="nTitle='"+myClass.replace(txtitle.Text)+"',";updateSQL+="nHtmlText='"+txtContent.Text+"'";dbobj.getcom("updatewebaboutset"+updateSQL+"whereid="+Request.QueryString["ID"]);Page.RegisterStartupScript("alert",@"<scriptLANGUAGE=JavaScript>alert('修改成功');window.location='about.aspx';</script>");}
解决方案
解决方案二:
intoSQL="webabout(nFile,nTitle,nHtmlText,ncode)values(";intoSQL+="'"+myClass.replace(txtid.Text)+"',";intoSQL+="'"+myClass.replace(txtitle.Text)+"',";intoSQL+="'"+txtContent.Text+"',";intoSQL+="'"+dbobj.getautoNum("webabout","nFile")+"')";红色部分帮你改了,少了一组单引号
解决方案三:
这个intoSQL+="'"+myClass.replace(txtid.Text)+"',";为int型,是没错啊
解决方案四:
intoSQL="webabout(nFile,nTitle,nHtmlText,ncode)values(";intoSQL+="'"+myClass.replace(txtid.Text)+"',";intoSQL+="'"+myClass.replace(txtitle.Text)+"',";intoSQL+="'"+txtContent.Text+"',";intoSQL+="'"+dbobj.getautoNum("webabout","nFile")+"')";红色部分帮你改了,少了一组单引号sql里nFile为整型这个intoSQL+="'"+myClass.replace(txtid.Text)+"',";为int型,是没错啊
解决方案五:
myClass.replace(txtid.Text)你这个函数是把他转换成整数嘛?dbobj.getautoNum("webabout","nFile")这是什么意思?产生code函数放到里面不对啊
解决方案六:
那这个要怎样改
解决方案七:
引用5楼xinqichen1234的回复:
那这个要怎样改
真的是函数啊?你把这个函数产生的dbobj.getautoNum("webabout","nFile")code存到一个变量里面假设产生code是string类型的stringcode=dbobj.getautoNum("webabout","nFile");然后在构造sql语句啊