if strsp_shl<>"" then
if not isnumeric(strsp_shl) then
response.Write"<script>alert('数量必须为数字!');window.location='javascript:history.back()';</script>"
response.end
end if
end if
set rs2=server.createobject("adodb.recordset")
sql="select * from dh_table"
rs2.open sql,conn,1,3
rs2.addnew
rs2("sp_type")=strck_name1
rs2("sp_name")=strck_name2
rs2.update
response.write "<script>alert('写入完成!!');window.location='kg.asp';</script>"
response.end
%>
修改数据与写入数据一样,只要去掉 rs2.addnew 就行.
'删除数据
<!--#include file="conn.asp"-->
<%
set rs=server.createobject("adodb.recordset")
sql="delete from ck_table where id="&request("id")
rs.open sql,conn,1,3