How to show limited number of data in REPEATER?

[2003et]

Hi,

I have a search system which shows results in REPEATER but, it shows, for
example 80 data item once, but I want to show the results page by page in
groups of 10.

1-10 11-20 21-30 ... etc.

How can I do this?

Note: I bind REPEATER with result DATASET...

Thanks in advance...

E.T.

 

[Bob Powell [MVP]]

Just limit the number of records that you get in the SQL statement.

SET ROWCOUNT 10
SELECT * FROM mytable
WHERE id>= (put the id of the record that you want to be the base of the 10
rows)

--
Bob Powell [MVP]
Visual C#, System.Drawing

Image transition effects, automatic persistent configuration and
design time mouse operations all in April's issue of Well Formed
http://www.bobpowell.net/wellformed.htm

Answer those GDI+ questions with the GDI+ FAQ
http://www.bobpowell.net/gdiplus_faq.htm

The GDI+ FAQ RSS feed: http://www.bobpowell.net/faqfeed.xml
Windows Forms Tips and Tricks RSS: http://www.bobpowell.net/tipstricks.xml
Bob's Blog: http://royo.is-a-geek.com/siteFeeder/GetFeed.aspx?FeedId=41

 

[2003et]

Thank you Bob...

Just limit the number of records that you get in the SQL statement.

SET ROWCOUNT 10
SELECT * FROM mytable
WHERE id>= (put the id of the record that you want to be the base of the 10
rows)

--
Bob Powell [MVP]
Visual C#, System.Drawing

Image transition effects, automatic persistent configuration and
design time mouse operations all in April's issue of Well Formed
http://www.bobpowell.net/wellformed.htm

Answer those GDI+ questions with the GDI+ FAQ
http://www.bobpowell.net/gdiplus_faq.htm

The GDI+ FAQ RSS feed: http://www.bobpowell.net/faqfeed.xml
Windows Forms Tips and Tricks RSS: http://www.bobpowell.net/tipstricks.xml
Bob's Blog: http://royo.is-a-geek.com/siteFeeder/GetFeed.aspx?FeedId=41

 

[2003et]

I think this can only work on SQL Server but I use MS ACCESS

 

[Bob Powell [MVP]]

Ah, so try:

SELECT TOP 10 *
FROM table
WHERE id><some number>

--
Bob Powell [MVP]
Visual C#, System.Drawing

Image transition effects, automatic persistent configuration and
design time mouse operations all in April's issue of Well Formed
http://www.bobpowell.net/wellformed.htm

Answer those GDI+ questions with the GDI+ FAQ
http://www.bobpowell.net/gdiplus_faq.htm

The GDI+ FAQ RSS feed: http://www.bobpowell.net/faqfeed.xml
Windows Forms Tips and Tricks RSS: http://www.bobpowell.net/tipstricks.xml
Bob's Blog: http://royo.is-a-geek.com/siteFeeder/GetFeed.aspx?FeedId=41