PageCount - property of the AdoRecordset object
Description:
Returns the number of pages with data in the
AdoRecordset object.
Use the
PageCount property to determine how many pages of data are in the
AdoRecordset object. Pages are groups of records whose size equals the
PageSize property setting. Even if the last page is incomplete because there are fewer records than the
PageSize value, it counts as an additional page in the
PageCount value.
If byl the
AdoRecordset object does not support this property, then the value will be -1, it means that the
PageCount is indeterminable.
Values:
num - The number of pages
Note:
Property access for read only.
Example:
JavaScriptVBScriptSelect and copy to clipboard
var nPageCount = oRs.PageCount;
Dim nPageCount
nPageCount = oRs.PageCount