how to make a page type recordset

[Jagmohan Negi]

How can i make a page type(ex google search) recordset as my SQL query returns a large number of records and to display them in a single page is not possible, so i want to display them 20 per page and buttons like perv. and next to move to prev. and next records.

Thanx for the help

[vishwam gandi]

You can do this by different methods
1. by setting up record set ,max row number in ur page as a session objects
traverse record set each time ur page called upto max row number of prevoius page.

2.fire ur query in page each time it is called & traverse upto max row number of prevoius page.

3. You can use a datagrid tag lib which is available at http://jakarta.apache.org/taglibs/index.html

I hope this solves ur problem