ASP中使用Set ors=oConn.Execute()時(shí)獲取記錄數(shù)的方法

%
Dim oConn, ors, aRows
Dim i,j
Set oConn=Server.CreateObject("ADODB.Connection")
oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" Server.MapPath("database/newasp.resx")
Set ors=oConn.Execute("Select TOP 5 SoftID,SoftName FROM NC_SoftList")
Response.Write "RecordCount:" ors.RecordCount "br/>" '-1
aRows=oRs.GetRows(-1) 'oRs.Eof=True,aRows(col,row)
Set ors=Nothing
oConn.Close()
Set oConn=Nothing

If IsArray(aRows) Then
Response.Write "RecordCount:" UBound(aRows,2)+1 "br/>"
For i=0 To UBound(aRows,2)
For j=0 To UBound(aRows,1)
Response.Write aRows(j,i)
If j> UBound(aRows,1) Then Response.Write ","
Next
Response.Write "br/>"
Next
End If
%>