How to display data in different order from the same table in Repeater that exists in many pages of the website?

Question

0.00/5 (No votes)

See more:

I have a Repeater that shows safety messages from the SafetyMessages 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 (I want the repeater to show the data from the database in each page in different order). 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:

SQL

SELECT MessageID, MessageDesc, MessageAuthor FROM [SafetyMessage]

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

Posted 11-Dec-11 6:08am

matrix388

Add a Solution

2 solutions

Solution 1

You can solve in by either changing in query or in code--

you can use order by clause in query or change sortexpression in different instances of repeater data source.
--Pankaj

Posted 11-Dec-11 6:55am

pankajupadhyay29

Comments

matrix388 11-Dec-11 13:08pm

Thanks for your help, but could you please show me your answers in a part of the code?

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Wonde Tadesse · Accepted Answer · 2011-12-11T07:05:00

The simplest way to achieve this is to make a UserControl [^] so that you will be able to pass the desired message in each page. You don't need to have a repeater control to display the message. The user control may be designed using labels that will display the message and a query that will accept different criteria in each page. Criteria will be passed from each page as property from the user control. I put a code fragment that helps you as a starting point.

C#

public partial class MyMessageBoard : UserControl
    {

        public string Criteria
        {
            get
            {

                if (ViewState["Criteria"] != null)
                    return ViewState["Criteria"].ToString();
                    else
                        return " assign default criteria";

            }
            set {
                if (value != null)
                    ViewState["Criteria"] = value;
            }
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                DisplayMessage();
            }
        }

        private void DisplayMessage()
        {
            // Put your ADO.Net code that helps to select message based on the criteria
            // SELECT MessageID, MessageDesc, MessageAuthor FROM [SafetyMessage] WHERE Criteria
            // Execute the query and get the result
            // Finally display the result in the label control.
            // lblMessage.Text = "";
        }

    }