I am displaying currently a 100 records in my table which are fetched from the databse.But i need to display only first 10 records in the table and there will be a next button.after clicking on that next 10 records have to be displayed. Similarly there will be a previous button ,on clicking that previous 10 records have to be displayed.
Assuming that the DB supports such a clause. Not all do. PostreSQL, for example, has the LIMIT and OFFSET clauses that make dataset paging almost trivial. [ March 11, 2005: Message edited by: Bear Bibeault ]