谁可以告诉下我ASP里怎么删除

来源:百度知道 编辑:UC知道 时间:2024/06/21 01:56:40
哪位高手告诉下我在ASP里怎么样实现这样的功能:""
比如:有这样的一段
编号 姓名 年龄 删除
1 某某 22 "删除"
2 某某 23 "删除"

当点打引号那个删除的时候就可以把这条里编号为1的这行记录删除,点2的时候把2的这行记录给删除!~!

我是用SQL数据库..在帮我改下吧
<%
dim conn,rs
set conn=server.CreateObject("ADODB.Connection")
conn.Open "Driver={SQL server};database=js;server=CFDB743F076F44E;uid=sa;pwd="
Set rs=server.CreateObject("ADODB.Recordset")
sql= "select * from liuyou where style='未处理'"
rs.open SQL,conn,3,2
response.Write("<p align=center></p>")
response.Write(" <table width=570 border=1 align=center cellspacing=0 bordercolor=#e0e9e9 bordercolorlight=#000000

bordercolordark=#FFFFFF bgcolor=#F0F8FF>")
response.Write("<tr>")
response.Write("<td width=100 align=center class=C9>人员编号</td>")
response.Write("</tr>"

<%
dim conn,rs
set conn=server.CreateObject("ADODB.Connection")
conn.Open "Driver={SQL server};database=js;server=CFDB743F076F44E;uid=sa;pwd="
Set rs=server.CreateObject("ADODB.Recordset")
sql= "select * from liuyou where style='未处理'"
rs.open SQL,conn,3,2
response.Write("<p align=center></p>")
response.Write(" <table width=570 border=1 align=center cellspacing=0 bordercolor=#e0e9e9 bordercolorlight=#000000

bordercolordark=#FFFFFF bgcolor=#F0F8FF>")
response.Write("<tr>")
response.Write("<td width=100 align=center class=C9>人员编号</td>")
response.Write("</tr>")
recCount =0
do while not rs.eof
recCount = recCount+1
response.write("<td width=100 align=center class=C9>" & rs("msgNo") &"</td>")
response