[url]http://www.aspfaq.com/show.asp?id=2120[/url]


"Utada P.W. SIU" <wing0508@hotmail.com> wrote in message
news:#OroLNVDEHA.2712@TK2MSFTNGP10.phx.gbl...
> it is better to using stored procedure to paging the record rather than
> using asp
> if you using asp, u are retreieve all record from db and page it, howeve,
if
> you using stored procedure, sql server will only return the number of
record
> u need for you.
>
> Advantage: network traffic is implemented
> paging speed is faster than using asp when number of records very large.
>
> "Rahul Chatterjee" <rahul@benesysinc.com> wrote in message
> news:%23PGBr0RDEHA.2768@tk2msftngp13.phx.gbl...
> > Hello All
> >
> > I want to do some paging with a data set that I retrieve from the db.
The
> > data is about 500 records. I want to display about 25 records per page.
> The
> > user would look at these records and make appropriate changes and
proceed
> to
> > the next page and see the next 25 records. If he wanted to go back to
the
> > previous page, he could do so and still see the changes that he has
made.
> > Finally, when he gets to the last page he could commit those changes by
> > hitting submit on the webpage.
> >
> > How would I accomplish this. Please advise.
> >
> > Thanks
> >
> >
> >
>
>