How can i retrive a specific amount of records
Posted on 2004-09-02
I have an App which Querys a database and gets the records from a SQL server
my strSQLlooks like this "SELECT Top 50 CDR.[key],CDR.CallingPartyNumber,CDR.CalledPartyNumber From CDR Order By CDR.[key] DESC"
that gets me the first 50 records but i would like to be able to get the next 50 etc, and go forth and back just like a kind of page control
what is the best way to get this effectively done