How to limit Repeater Control to 5 records?

[chrigil]

How can I limit a repeater control to 5 records out of the database?

I wanna make a gallery page and the Repeater control seems like the best one to use because I can control the HTML and lay it out how I want.
The trouble is however that I also want to page the results by 5 items per page for example.
Is this possible with a repeater or do I have to write some sort of custom paging device?



Thanks in advance,

Chris

 

[ca8msm]

You would have to use paging or only return records between certain row numbers (I know in oracle you can use a rownum function) although this is essentially what paging does.

Also, there is an article on paging with a repeater control at:

http://www.charon.co.uk/content.aspx?CategoryID=28&ArticleID=21

Hope this helps.

----------------------------------------------------------------------

Need help finding an answer?

Try the search facilty (

http://www.tek-tips.com/search.cfm)

or read FAQ222-2244 on how to get better results.