0

I have a Repeater that shows safety messages from the Safety Messages Table in the database. Since I will put this Repeater in many pages of the Website, I want to this Repeater to show different messages in each page. For example, if it shows message#1 in this page as a first message then message#2 and so on, it should show message#10 as a first message in the other web page and so on. So how to do that?

My query is very simple like this:

SELECT MessageID, MessageDesc, MessageAuthor FROM [SafetyMessage]

Is this issue related to the query? Or it can be done from the Repeater itself?

UPDATE: I want the repeater to show the data from the database in each page in different order

Mohammed Al-Ali
  • 75
  • 2
  • 10

1 Answers1

0

What you want is called "paging support". Here is an article with an example of how to do it.

Edit: Based on further information from OP...

It sounds to me like what OP is asking for is paging and sorting.

This article explains how to do paging and sorting with a repeater control.

Joel Brown
  • 14,123
  • 4
  • 52
  • 64