ASP求表格里的价格总和出现问题

<%
rs.MoveNext
Wend
%>
                            <tr bgcolor="#F0FCFF">
                              <td height="25" ColSpan="9" Align="Right"><div align="left">&nbsp;&nbsp;合计：&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
                             <%
                            numprice=0
do while not rs.eof
numprice=numprice+rs("price")
rs.movenext
loop
response.write numprice
%>元</div></td>-----------红色的部份放在                            <%
rs.MoveNext
Wend
%>之后得出的是0元,
如果放在 <%
rs.MoveNext
Wend
%>得出表格只有一列,能求出总和,真晕头!