Tools Links Login

ADOPageControl

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.

Original Author: Barry Pranklin

Inputs

ConnectString As String
Sql As String
ShowPage As Long
PageSize As Long

Assumptions

You will need these objects. They come with VB6
Microsoft ActiveX data objects 2.1 Library
Microsofr Remote Data services server 2.1 Library

Returns

Rs As ADODB.Recordset
ErrorC As String
PageCount As Long

Side Effects

None that I know of.

About this post

Posted: 2002-06-01
By: ArchiveBot
Viewed: 114 times

Categories

Visual Basic 6

Attachments

CODE_UPLOAD30601252000.zip
Posted: 9/3/2020 3:45:00 PM
Size: 4,114 bytes


Loading Comments ...

Comments

No comments have been added for this post.

You must be logged in to make a comment.