ADO PAGES via VB
-
I have open ADO recordset with several pages. when user enter some number i want to display whole page which contains that user enters filed.
And I need to do this in VB
My Blog:
http://dineshasanka.spaces.live.com/ -
Can you be more specific on this?
Do you want to show some kind of summary?
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
OK Frank Kalis
Say I have 1000 records
And i have open ado which has page size = 100
there fore there are 10 page
If I enter some key of 125th record , It should display me the second page
My Blog:
http://dineshasanka.spaces.live.com/ -
Although there are several methods for paging qith SQL Server data available, I would transfer all data once at the beginning with GetRows(). So now you have an array and can easily locate your row element and jump to the second page. I bet you'll find code examples (if not here, than surely on ASP related site like http://www.4guysfromrolla.com
HTH
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply