by Bazzapr (2 Submissions)
Category: Databases/Data Access/DAO/ADO
Compatability: Visual Basic 3.0
Difficulty: Advanced
Date Added: Wed 3rd February 2021
Rating: (10 Votes)
Have you ever wanted data to be returned a page at a time? For example the data you requested returns 200 rows and you want to return them to the user 1 page at a time? Well now you can!
PS!! Do not forget to rate this software. This results in more code!! Thanks.
Inputs
ConnectString As String
Sql As String
ShowPage As Long
PageSize As Long
Assumes
You will need these objects. They come with VB6
Microsoft ActiveX data objects 2.1 Library
Microsofr Remote Data services server 2.1 Library
Code Returns
Rs As ADODB.Recordset
ErrorC As String
PageCount As Long
Side Effects
None that I know of.
Download ADOPageControl (4 KB)