I want to display 20 results from a resultset and give the
options for next and previous pages with 20 results in each page.I
am using asp and sql server.
I know that MySQL has feature LIMIT OFFSET, but in SQL SERVER
- TOP & SET ROWCOUNT commands only displays only the top rows,I
mean 1-20 in the first page can be displayed but in the next page
how to display rows from 21-40? I am really confused??? Looks like
a simple thing but I couldnot find solution for it.I will be very
thank ful to anyone who can help me with this.
You can set the total number of rows to display from within
region server behaviour and then navigate the records using
Recordset Navigation Behaviour from the insert bar, you can
under the Application tab.
DW automates this for you, you just need to select the