c# - Sort rows of DataTable in particular order we want

Question

Consider I have DataTable with two columns

Column1	Column2
abc	jan
def	dec
cba	feb
bdf	nov
aaa	dec

Answer 1

Add an expression based column

dataExistingTable.Columns.Add("MonthNumber", typeof(int),
    "IIF ([Column2] = 'dec', 12, (IIF ([Column2] = 'nov', 11, (IIF ([Column2] = 'oct', 10, (IIF ([Column2] = 'sep', 9, 8)))))))");

Then apply sort on expression based column

dataExistingTable.DefaultView.Sort = "MonthNumber desc";

Then DefaultView of the table will give your sorted rows.

// dataExistingTable.DefaultView;