asp刪除資料庫教學記錄其實在asp中是很非常容易做的事情了，只要連接資料庫了，再利用sql delete函數來刪除就ok了，下面來看看實例吧。刪除單一記錄
複製代碼代碼如下:
id = saferequest(id)
sql=delete from table1 where whereid>&id&
rs.open sql,conn,1,3
response.write <script>alert('刪除成功');location.href='del.asp';</script>
set rs=nothing
set conn=nothing
這是過濾非法字元函數
複製代碼代碼如下:
function saferequest(paraname)
dim paravalue
paravalue=request(paraname)
if isnumeric(paravalue) = true then
saferequest=paravalue
exit function
elseif instr(lcase(paravalue),select ) > 0 or instr(lcase(paravalue),insert ) > 0 or instr(lcase(paravalue),delete from) > 0 or instr(lcase(paravalue),count() > 0或 instr(lcase(paravalue),drop table) > 0 or instr(lcase(paravalue),update ) > 0 or instr(lcase(paravalue),truncate ) > 0 or instr(lcase(paravalue),asc() > 0 或 instr(lcase(paravalue),mid() > 0 或instr(lcase(paravalue),char() > 0 or instr(lcase(paravalue),xp_cmdshell) > 0 or instr(lcase(paravalue),exec master) > 0 or instr(lcase(paravalue),net localgroup administrators) > 0 or instr(lcase(paravalue), and ) > 0 or instr(lcase(paravalue),netase(paravalue),net user) > 0 or instr(lcase(paravalue), or ) > 0 or instr(lcase(paravalue),)>0 或 instr(lcase(paravalue),')>0 then
response.write 請不要在函式中加入非法字元！
response.end
else
saferequest=paravalue
end if
end function
批量刪除方法：
主要是利用for迴圈來實現。
複製代碼代碼如下:
id=request.form(checkbox)
id=Split(id,,)
shu=0
for i=0 to UBound(id)
sql=select * from jiang_fname where id=&id(i)
set rs=conn.execute(sql)
shu=shu+1
next