sorting columns using particular words in c#
<p>i have a table with a column named size which will have values big,medium and small. wat i want is i want to sort this column in such a way that all rows with size big should come first, then rows with size medium and finally rows with size small.
is there a way by which i can achieve this?</p>

<p>edit: it is a data table which i add to a dataset.</p>

<p>edit: wat if the initials of the words, in this case b,m and s, are not in alphabetical order. in that wat am i supposed to do coz i have another application as well where i'll be required to sort a column having value High, normal and low. </p>
