Question

access数据库和asp页面，怎样才能把文本框里的值传到数据库中

Answer 1

<% action=request("action") '或 action=request.form("action"))
if Action="save" then
set rs=server.createobject("adodb.recordset")
Sql="select * from [表名]"
rs.open sql,conn,1,3
rs.addnew
rs("ads")=trim(request.form("ads"))
....略......
rs.Update
rs.close
set rs=nothing
response.Write "<script language='javascript'>alert('提交成功！');location.href='xx.asp';</script>"
response.End
end if %>
<form name="myform" action="?Action=save" method="post">
地址:<input name="ads" type="text" id="ads" size="50" maxlength="50" />
....略....
<input type="submit" name="Submit2" value=" 提交 " /></form>

Answer 2

链接数据库 用DW做！

追问

没有DW，就想知道语句怎么写