ASP中使用Set ors=oConn.Execute()时获取记录数的方法

复制代码 代码如下:

  <%

  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

  %>