Publisher review:Recordset GetRows Method lets you retrieve the resultset and place into a two-dimensional array. The GetRows method of the Recordset object lets you retrieve the resultset and place into a two-dimensional array. The code then loops through that 2 dimensional array 'ArrResults' and displays the records.
The standard way to retrieve and display records has been to create a recordset object and loop through the records, though with the GetRows method there is only one call to the database making for more efficient code. In this script, the UBound function returns the index of the highest element in the array for both dimensions, this basically lets you know how many times to loop through both the rows and columns.
Recordset GetRows Method is a ASP.NET script for Snippets scripts design by Michael Wall.
It runs on following operating system: Windows.
Operating system:Windows