ÔÚ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
Ïà¹ØÎÊ´ð£º
<form id="form1" runat="server">
<div>
<script type="text/javascript">
function oo(a){
document.getEleme ......
ÎÒÔ±¾ÊÇѧjspµÄ¿ÉÕÒÁËÒ»¸öASPµÄ¹«Ë¾£¡ÎÒÒªÖØÐÂѧϰ£¡ ѧϰASP£¡ Ï£Íû´ó¼ÒÍÆ¼öÒ»±¾ºÃÊ鏸ÎÒлл
<ASP3.0¸ß¼¶±à³Ì> ÍøÉÏÓеç×Ó°æµÄ
·¢ÏÖÍøÉÏaspÐÅϢʱ×î¶àµÄ ±ÈÆäËûµÄ¶¼¶àºÃ¶à
yun
ÕÒ±¾ÓÐÓ¦ÓÃÊÂÀýµÄA ......
<%
Sql="select top 8 * from NewsData where d_classid in (select classid from NewsClass where ParentID=16)"
Rs.Open Sql, conn, 1,1
Do Until Rs.Eof
......
ÓÐËÄܸø½²½²£¬Ôõô×öÂð£¿
ллÀ²£¡
¸ÊÌØÍ¼ ÊÇɶ£¿
½âÌâ˼·.¿´Ò»Ï½ø¶ÈÌõµÄÏÔʾ..
ÆäʵÄã¾ÍŪһ¶Ñtable ÿ¸ötableµÄ¿í¶È²»Í¬.µ×É«²»Í¬¼´¿É
µ±È»ÓÃdiv¿ØÖÆÎ»ÖøüºÃ
ÄãŪ100¸ötable¸ù¾Ý½ø¶ÈÆäÖÐǰ20¸ö·Ö¸øµ ......