<% do while not rs.eof
%>
<tr bgcolor="#ECF0FC">
<td colspan="4"><form action="edit.asp?id=<%=rs(0)%>" method="post" name="form1">
<table width="600" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="150" valign="bottom"><%= rs(1) %>&nbsp;</td>
<td width="150"><input name="sex" type="text" id="sex" value="<%=rs("sex")%>"></td>
<td width="150"><input name="qx" type="text" id="qx" value="<%=rs("qx")%>"></td>
<td width="150"><div align="center">
<input name="bt<%=rs(0)%>" type="submit" id="bt" value="保存">
</div></td>
</tr>
</table>
</form></td>
</tr>
<% rs.movenext
loop %>
edit.asp
<% id=request.QueryString("id")
sex=request.Form("sex")
sql="update yewu set sex='"&sex&"' where yid="&id
conn.execute sql
%>