custom paging using oracle procedure in .net C#

  • Thread starter Thread starter netdev
  • Start date Start date
N

netdev

Hi,

I am developing a oracle procedure for using custom paging in one of
the project where in we are getting thousands of records into cache. To
avoid this, i am creating orcale procedure to use custom paging for
data grid. Can any one please provide some inputs, if you have done
something like this.

Regards,
netdev
 
I would start with an article like:
http://www.vbdotnetheaven.com/Code/Sept2003/2173.asp

The main thing you need is a pointer to the first and last record. If this
is an integer field that is auto incremented (realizing you have to pull and
insert in Oracle as there is no true auto-increment), you will have a first
number and a last number. Use those as pointers to pull records before and
after the current set.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

*************************************************
Think Outside the Box!
*************************************************
 
Back
Top