VB LINQ 排序欄位 容許空值

LINQ: OrderBy with nullable columns in TypedDataSets

http://www.gbogea.com/2008/08/11/linq-orderby-with-nullable-columns-in-typeddatasets

        evensQuery = (From task In tblTaskShow.AsEnumerable _

          Select task Order By IIf(IsDBNull(task("TRNDATE")), "", task("TRNDATE")), task("MAC"))

在 Order By 之後判斷是否空值,以空字串取代

IIf(IsDBNull(task("TRNDATE")), "", task("TRNDATE"))