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());
}
