display a certain range of records

[redshirtme]

in asp.net web app.
How should I write code/sql query to extract from the 22nd records to 53rd records from a table ? 22nd and 53rd would be parameters and I don't want to rely on id field in the table because ID can have random gaps between records.

I hope the sub range of records would be populated to a data reader or some thing so that I could use dr("table_field_name") to retrieve it later.


thanks for your help!

[Magiaus]

Select you data into a temp table with it's own autonum id. then select from that table.