Question

asp表单提交到数据库的问题

如何实现从表单读取数据然后写入数据库（自己写的总是无法写入到数据库）谢谢

Answer 1

<!--#include file="jiancha.asp"--> <!--#include file="../hanshu.asp"--> <% biaoti=request.form("biaoti") xuqiu=request.form("xuqiu") if biaoti="" then response.write "<script language=javascript>alert('标题不能为空');location.href='baojiadan.asp';</script>" response.end() end if if xuqiu="" then response.write "<script language=javascript>alert('需求不能为空');location.href='baojiadan.asp';</script>" response.end() end if sql2="select * from yonghu_id where zx_id= " & session("zx_id") set rs2=server.createobject("adodb.recordset") rs2.open sql2,conn,2,3 if rs2.eof then response.write "<script language=javascript>alert('登陆超时或你还未登陆，请重新登陆');location.href=loginout.asp';</script>" response.end() end if rs2("xxjf_id")=rs2("xxjf_id")+3 rs2("xit_id")=rs2("xit_id")+1 rs2.update rs2.close set rs2=nothing sql1="select * from z_dingyi" set rs1=server.createobject("adodb.recordset") rs1.open sql1,conn,2,3 rs1.addnew rs1("biaoti")=biaoti rs1("xuqiu")=xuqiu rs1("zx_id")=session("zx_id") rs1("fbsj_id")=now() rs1.update rs1.close set rs1=nothing response.write "<script language=javascript>alert('自定义报价单添加成功！\n\n请等待装机师审核');location.href='baojiadan.asp';</script>" response.end() %>