在asp中删除table中的数据

在table中显示数据：编号(id)，学号...，如何得到一行数据的id值，然后把这一行删除了？
同时也有入学日期，如何得到日期，把数据进行批量删除？

---

nan

---

不是太明白问题。
SQL code:
delete from table1 where id=1

delete from table1 where date = '2009-01-01'

---

HTML code:

<table>
<tr>
<td>ID</td>
<td>学员姓名</td>
<td>入学日期</td>
<td>操作</td>
</tr>
<%
set rs=********
rs.open "select * from 表",conn,1,1
循环
%>
<td><%=Rs("id")&></td>
<td><%=Rs("name")&></td>
<td><%=Rs("time")&></td>
<td><a href="del.asp?id=<%=Rs("id")%>">删除</a></td>
</table>

---

<%
sql = "SELECT * from [table_name]"
rs.open sql, conn, 1, 1
sql = "DELETE from [table_name] where id=" & rs("id")
conn.execute("sql")
%>

---

VBScript code:
rs.open "select * from table",conn,1,3
whil