Page searching

[Guest_imported]

Hi all,

I am using a SQL 2000 backend and .NET as the frontend. I would like to have the functionality to display 50 records at a time to my users.

Once I have figured that out, I would like to allow my user the functionality to select a row to start at and then display the next 50 after that.

At first I thought it was a SQL statement that would allow me this functionality. In Oracle I can use the ROWNUM function to specify what rows I want, but on the sql forum they mentioned it maybe a question for here...

Anyone offer opinions or examples of this functionality?

 

[perryf]

I would assume you are selecting records by the Pk. You can just use something like:

Select TOP n FROM x WHERE Table.PK > CurrentPkValue

 

[alionline]

I have found this article (example paging).
Just edit the store procedure to add your searching variable (code).

http://www.dotnetjunkies.com/tutorials.aspx?tutorialid=50

-aliahmad dot net-