repeat rows?
Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: ASP.NET Discussion
Forum Description: Discussion and chat on ASP.NET related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=7649
Printed Date: 28 March 2026 at 2:24am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: repeat rows?
Posted By: Boecky
Subject: repeat rows?
Date Posted: 27 November 2003 at 8:27am
|
Hello, How can I tell a repeater how many rows he has to display? Is it possible? If not can someone tell me the sql code how to display the first 3 rows? I'm already searching a couple hours... |
Replies:
Posted By: Mart
Date Posted: 27 November 2003 at 9:25am
|
Ahh paging a repeater. Thats why i try not to use them. What i did once was: Dim SQL As String ="SELECT TOP 3 * FROM table WHERE ID > " & Cint(request.querystring("LID")) Then to move to the next page set the querystring paramiter "LID" to the last ID of the record displayed. |
Posted By: Diep-Vriezer
Date Posted: 27 November 2003 at 11:32am
|
Or use a datagrid. Why hasn't a repeater got a paging function.. Not really like the rest of .NET. ------------- Gone.. |
Posted By: Mart
Date Posted: 27 November 2003 at 1:46pm
| You can't use a Datagrid for somethings. because they need a non tabular feel. And i agree the repeater control should have built in paging... |
Posted By: Diep-Vriezer
Date Posted: 27 November 2003 at 3:22pm
|
=/ I don't use the repeater that much, but it is quite simple and fast. ------------- Gone.. |
Posted By: Boecky
Date Posted: 28 November 2003 at 12:18am
Yes, any paging should be an option of repeater...maybe in asp.net 2 But thanks Mart, this sql works great! SELECT TOP 2 * FROM table |