custom paging using oracle procedure in .net C#

20 Aug 2006 4:18 PM

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

21 Aug 2006 1:01 PM

Cowboy (Gregory A. Beamer)

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!
*************************************************

Show quote

"netdev" <NetDe***@gmail.com> wrote in message
news:1156090733.236161.35200@p79g2000cwp.googlegroups.com...
> 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
>