Ordering a list using SQL number list
===

I am looking for a way that would allow me to have a column that I would simply manually input a number and then the list would sort itself based off this list, this would be using c# as the language for the listing and it's ms SQL

I don't have much information, but if anyone wants to know anything else feel free to ask and I will try and answer to my best ability.

Example of how I would like this to work:

I would have a column in my database named "DisplayOrder" or something along those lines.

Database row says "1", this would be the first item in a list to appear.
Database row says "8", this would be the 8th item in the list to appear.