public DataView GetBooksSortedByAuthorDescending() { DataView result = null; var data = new Module6DataAccess(); var dt = data.GetBooksAsDataTable(); if (dt != null) { result = dt.DefaultView; result.Sort = "Author DESC"; } return(result); }
public DataTable GetTransactionsLessThan(decimal amount) { DataView result = null; var data = new Module6DataAccess(); var dt = data.GetTransactionsAsDataTable(); if (dt != null) { result = (from trn in dt.AsEnumerable() where trn.Field <decimal>("Amount") < amount orderby trn.Field <decimal>("Amount") descending select trn).AsDataView(); } return(result.ToTable()); }