if (Request.QueryString["id"] == null)
{
string intoSQL = "";
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("insert into " + intoSQL);
Page.RegisterStartupScript("alert", @"<script LANGUAGE=JavaScript>alert('添加成功');window.location='about.aspx';</script>");
}
else
{
string updateSQL = "";
updateSQL += "nTitle='" + myClass.replace(txtitle.Text) + "',";
updateSQL += "nHtmlText='" + txtContent.Text + "'";
dbobj.getcom("update webabout set " + updateSQL + " where id=" + Request.QueryString["ID"]);
Page.RegisterStartupScript("alert", @"<script LANGUAGE=JavaScript>alert('修改成功');window.location='about.aspx';</script>");
}
{
string intoSQL = "";
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("insert into " + intoSQL);
Page.RegisterStartupScript("alert", @"<script LANGUAGE=JavaScript>alert('添加成功');window.location='about.aspx';</script>");
}
else
{
string updateSQL = "";
updateSQL += "nTitle='" + myClass.replace(txtitle.Text) + "',";
updateSQL += "nHtmlText='" + txtContent.Text + "'";
dbobj.getcom("update webabout set " + updateSQL + " where id=" + Request.QueryString["ID"]);
Page.RegisterStartupScript("alert", @"<script LANGUAGE=JavaScript>alert('修改成功');window.location='about.aspx';</script>");
}
解决方案 »
- SQL数据库中添加信息
- 关于xp xp2,win2000 安装fw3.5?
- 用C#怎么实现自动注册?
- sql语句中怎么取OUTPUT参数的值?内详.
- VS2003开发的程序, 在部署到VS2005时运行不正常, 为什么?
- 急!!!!!如果在刷新treeview后,让某个节点被选中,该节点显示兰色显示
- C#调用嵌入的资源竟抛异常,曰“内存不足”???
- Input string was not in a correct format
- 非常苦恼的问题!请牛人帮忙~~~分不够可以再加,UP有分
- 请教:创建程序时提示“Automation服务器不能创建对象”的错误
- 如何统计一个文件夹里每个文件的代码行数
- C# 如何将从文本文件读入的字符串进行处理,去掉标点呢(英文文档)
intoSQL += "'" + myClass.replace(txtid.Text) + "',";
intoSQL += "'" + myClass.replace(txtitle.Text) + "',";
intoSQL += "'" + txtContent.Text + "',";
intoSQL += "'" + dbobj.getautoNum("webabout", "nFile") + "')";
红色部分帮你改了,少了一组单引号
为int型,是没错啊
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型,是没错啊
dbobj.getautoNum("webabout", "nFile")这是什么意思?产生code函数放到里面不对啊
你把这个函数产生的dbobj.getautoNum("webabout", "nFile") code存到一个变量里面
假设产生code是string类型的
string code=dbobj.getautoNum("webabout", "nFile");
然后在构造sql语句啊