I am using Microsoft.CommerceServer.SearchOption class to sort a GridView
either ASC or DESC. The search is performed on a Profile class.
profile.ExecuteSearch() does not work correctly when SortDescending is set
to true. It always returns in ascending order.
searchOption.SortProperties ="PropName";
searchOption.SortDescending=true;
profile.ExecuteSearch(entity, filter, searchOptions);
I also tried searchOption.SortProperties="[PropName]DESC" which raises an
exception because it cannot find the property.
I used SQL profiles and it shows that in both scenarios the order is done
in
ascending order.
Any help would be very much appreciated. Please note I am new to Commerce
Server.