Thanks, man. that is quick!
yes. this is what I did. the problem is I also need offerCounter field.
in order to get both last offer and offer count, I query database twice,
1) get the ItemId and offerCounter,
2) query database again just like your did in your code, to get itemId and lastOffer info,
3) add a new datacolumn "OfferCount" in second resultTable,
4) update "OfferCount" value from first result table.
It is not very good to query database twice, especially with paging and sorting in the page. I really like to get all the data in one shot.
right now, I disabled sort for OfferCount
better solution?
supper thanks for your help!