asp查询结果,将每条数据的两个字段放到二唯数组,后边在遍例取出

[hcqhappy]

sql="select top 10 id,biaoti from xinwen order by fbsj DESC"

查询结果将 id biaoti 对应的数据 放到二唯数组 如果查询条数不够 放"" 进去

后边在 打出 每条记录对应的id biaoti

请给出较完整的程序 谢谢了

[KimSoft]

recordset 对象有个自带的getrows方法，可以直接得到你想要的结果

详细请参考：
http://www.webjx.com/htmldata/2005-08-21/1124584431.html

[hbjmdx008]

dim total(10,2)
do while not rs.eof
total(i,1)=rs("id")
total(i,2)=rs("biaoti")
rs.movenext
loop

[devilzone]

sql="select top 10 id,biaoti from xinwen order by fbsj DESC"
Set Rs = Server.CreateObject("Adodb.RecordSet")
Rs.Open Sql,Conn,1,1
Dim temArray(1,9)
for i = 0 to 9
If Not Rs.Eof Then
temArray(0,i) = Rs(0)
temArray(1,i) = Rs(1)
Rs.MoveNext
Else
temArray(0,i) = ""
temArray(1,i) = ""
End If
Next
for i = 0 to 9
Response.Write "id:"&temArray(0,i)&"; biaoti:"&temArray(1,i)&"<br>"
Next