Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

table with paging in asp?

Options
  • 03-04-2002 10:03am
    #1
    Scruff
    Registered Users Posts: 4,222 ✭✭✭


    Does anyone know how to create a table in asp with paging?

    Scenario: sql query to db returns x amount of rows to a recordset which is displayed in a table on the browser. However if theres 100 rows returned, these all are getting displayed on the one page.

    how would you create a table with say 20 rows to be displayed per page in such a way that if you were to click on the "next page" button\link it would dispay the next 20 rows in the recordset from the sql query without having to requery the database?

    Tried doing this with Design Time Controls using the grid ( developing in MS InterDev) but this will only work if querying 1 static database connection, but i've dynamic database connection implemented on the page as its a multiple database project. only need to connect to one database at a time though to display results.

    No row navigation or the like needed, just paging.
    any ideas? Cheers.


Advertisement