您的位置首页百科知识

asp 操作 ACCESS

asp 操作 ACCESS

a.asp(以下代码在a.asp)<改培老%if request("action")="del" thenid=request("id")sql="delete form B where id="&id&""conn.execute(sql)response.write""end ifset rs=server.createobject("adodb.recordset")sql="select * from B order by id desc" '打开B表并自动排序rs.open sql,conn,1,1do while not rs.eof '核升循环显示B表的中肆资料%>

<%=rs("id")%>>删除
<%rs.movenextif rs.eof then exit dolooprs.closeset rs=nothing%>