OK,今天在论坛看到好多人说插入记录不成功和插入不进去等，问题所有就写个简单的插入好了,安全性没考虑
开始，首先是前台代码如下:
<table width="50%" border="1" cellspacing="0" cellpadding="0" align="center">
<form name="form1" action="aspt1.asp">
<tr>
<td width="21%" height="47">原代码名称</td>
<td width="79%"><input type="text" name="mingz" size="20" /></td></tr>
<tr> <td width="21%" height="48">原代码介绍</td>
<td><textarea name="jies" ></textarea></td></tr>
<tr> <td width="21%" height="46">大小</td>
<td><input type="text" name="daxiao" size="20" /></td></tr>
<tr> <td width="21%" height="51">日期</td>
<td><input type="text" name="rqi" size="20" /></td></tr>
<tr> <td width="21%" height="34">备注</td>
<td><input type="text" name="bzhu" size="20" /></td></tr>
<tr> <td width="21%" height="40">下载</td>
<td><input type="text" name="xzdiz" size="20" /></td></tr>
<tr ><td colspan="2" align="center"><input name="submit" type="submit" value="添加" /></td></tr>
</form>
</td>
</tr>
</table>
在就是后台了
<!--#include file="conn.asp"-->
<% dim mingz,jies,daxiao,rqi,xzdiz,bzhu
mingz=trim(request("mingz"))
jies=trim(request("jies"))
daxiao=trim(request("daxiao"))
rqi=now()
xzdiz=trim(request("xzdiz"))
bzhu=trim(request("bzhu"))
set rs=server.createobject("adodb.recordset")
sql="select * from yuanma "
rs.open sql,conn,1,3
rs.addnew
rs("yuandaima")=mingz
rs("jies")=jies
rs("daxiao")=daxiao
rs("rqi")=rqi
rs("xzdiz")=xzdiz
rs("bzhu")=bzhu
rs.update
rs.close
set rs=nothing
response.Write("<script>alert('添加成功');window.open('aspguanli.asp', 'nihao');</script>")
%>
OK就这样就可以添加成功了，解释下上面包含的文件是连接数据库文件(conn.asp),