How to show limited number of data in REPEATER?

  • Thread starter Thread starter 2003et
  • Start date Start date
2

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.
 
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
 
Thank you Bob...

Bob Powell said:
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
Click to expand...
 
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
 
Back
Top