asp 中当删除一条记录，记录ID号怎么制动的变化？

删除前

删除后

代码如下：<td valign="top" bgcolor="#FFFFFF"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="40" colspan="4"><img src="/images/sofa1.gif" width="44" height="37"><span class="style6"><span class="style10"> 最新新闻：&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp; &nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; &nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; &nbsp;&nbsp; &nbsp;&nbsp;&nbsp; <a href="news_add.asp" class="style10">新增新闻</a> </span></span></td>
</tr>
<tr>
<td height="25" colspan="4">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;
记录 <%=(rs_admin_first)%> 到 <%=(rs_admin_last)%> (总共 <%=(rs_admin_total)%> )</td>
</tr>
<tr>
<td width="13%"><div align="center">序列号</div></td>
<td width="53%"><div align="center">新闻标题</div></td>
<td width="23%"><div align="center">加入时间</div></td>
<td width="11%">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 编辑</td>
</tr>
<tr>
<td colspan="4" height="25"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<%
While ((Repeat1__numRows <> 0) AND (NOT rs_admin.EOF))
%>
<tr>
<td width="13%" align="center"><%=(rs_admin.Fields.Item("ID").Value)%></td>
<td width="53%"><a href="newscontent.asp?<%= Server.HTMLEncode(MM_keepNone) & MM_joinChar(MM_keepNone) & "ID=" & rs_admin.Fields.Item("ID").Value %>"><%=(rs_admin.Fields.Item("title").Value)%></a></td>
<td width="21%"><%=(rs_admin.Fields.Item("time").Value)%></td>
<td width="7%"><a href="/news/news_upd.asp?<%= Server.HTMLEncode(MM_keepNone) & MM_joinChar(MM_keepNone) & "ID=" & rs_admin.Fields.Item("ID").Value %>">修改</a></td>
<td width="6%"><a href="/news/news_del.asp?<%= Server.HTMLEncode(MM_keepNone) & MM_joinChar(MM_keepNone) & "ID=" & rs_admin.Fields.Item("ID").Value %>">删除</a></td>
</tr>
<%
Repeat1__index=Repeat1__index+1
Repeat1__numRows=Repeat1__numRows-1
rs_admin.MoveNext()
Wend
%>

<tr>
<td colspan="5" align="center">&nbsp;
<table border="0">
<tr>
<td><% If MM_offset <> 0 Then %>
<a href="<%=MM_moveFirst%>">第一页</a>
<% End If ' end MM_offset <> 0 %>
</td>
<td><% If MM_offset <> 0 Then %>
<a href="<%=MM_movePrev%>">前一页</a>
<% End If ' end MM_offset <> 0 %>
</td>
<td><% If Not MM_atTotal Then %>
<a href="<%=MM_moveNext%>">下一页</a>
<% End If ' end Not MM_atTotal %>
</td>
<td><% If Not MM_atTotal Then %>
<a href="<%=MM_moveLast%>">最后一页</a>
<% End If ' end Not MM_atTotal %>
</td>

不要读取ID字段的值作为序列号！可以在循环语言中设置一个变量，比如：i 。然后 i 每循环一次加1。把该变量作为序列号就行了！

这个序号是直接从数据库里读取的id，字段id是关键字段，递增。删除一条记录后，数据的库整个id字段数据都不会变得。如果想得到按记录数来计算的序号，就要自己在后台写循环语句来显示。