Datalist - Show information in reverse order.

Question

I have a datalist that shows information from a SQL table perfectly. Is there a way to show the information in reverse order?

Example:

Person1 Person2 Person3

Instead I would like:;

Person3 Person2 Person1

Answer 1

see the DESCENDING option of SELECT

Answer 2

Modify your SQL query to use ORDER BY <name> DESC.

Answer 3

If you don't want to do it server-side you could also use the Reverse extension method:

var items = myDataList.Items;
myDataList.Items = items.Reverse();

or more succinctly, but less obvious:

myDataList.Items = myDataList.Items.Reverse();