Bind distinct data to repeater using linq to object distinct

Question

I am trying to filter records basis on distinct . I used the following code

List<BALHotelList> searchresult = (from a in bh
                                           join b in hr on a.HotelCode equals b.hotelCode
                                           orderby a.HotelName
                                           select new BALHotelList
                                               {
                                                   HotelCode = a.HotelCode,
                                                   ImageURL_Text = a.ImageURL_Text,
                                                   HotelName = a.HotelName,
                                                   StarRating = a.StarRating,
                                                   HotelAddress = a.HotelAddress,
                                                   Destination = a.Destination,
                                                   Country = a.Country,
                                                   HotelInfo = a.HotelInfo,
                                                   Latitude = a.Latitude,
                                                   Longitude = a.Longitude,
                                                   HotelArea=a.HotelArea,
                                                   totalPrice = b.totalPrice,
                                                   totalPriceSpecified = b.totalPriceSpecified,
                                                   totalSalePrice = b.totalSalePrice,
                                                   totalSalePriceSpecified = b.totalSalePriceSpecified,
                                                   rooms = b.rooms,
                                                   boardType = b.boardType

                                               }).ToList();

        var uniqueArea =searchresult.Select(m => m.HotelArea).Distinct();


  rptHotelArea.DataSource = uniqueArea;
        rptHotelArea.DataBind();

but it's not finding HotelArea in data source .

but when i debug its shows me all distinct values in uniqueArea

the error is as following:

DataBinding: 'System.String' does not contain a property with the name 'HotelArea'.

EDITED

Here is repeater HTML

  <asp:Repeater ID="rptHotelArea" runat="server">
        <ItemTemplate>
            <div class="sub-part1">
                <a href="#"><%#Eval("HotelArea")%></a></div>
        </ItemTemplate>
    </asp:Repeater>

Please take a look at the answer for this question: http://stackoverflow.com/questions/5011617/asp-net-repeater-bind-liststring. — Sergey Vyacheslavovich Brunov, Jul 30 '12 at 08:44
@Serge +1 its works . one more thing whether null be treated as unique in distinct case — rahularyansharma, Jul 30 '12 at 08:48
var uniqueArea =searchresult.Select(m => m.HotelArea).Where(m => m != null).Distinct(); — Sergey Vyacheslavovich Brunov, Jul 30 '12 at 09:01
and what about empety string ? please post your comments as answer so i can accept it . Its more near then jon answer — rahularyansharma, Jul 30 '12 at 09:18

score 1 · Answer 1 · answered Jul 30 '12 at 08:33

1

You've already selected HotelArea here:

var uniqueArea = searchresult.Select(m => m.HotelArea).Distinct();

... so in your databinding you should just select the value itself.

If you need the whole information within the data source, rather than just the hotel area, you'd need something like DistinctBy from MoreLINQ.

answered Jul 30 '12 at 08:33

Jon Skeet

1,421,763
867
9,128
9,194

yes, and var uniqueArea show me the list of string when i debug of distinct HotelArea , but it fails when i bind this to repeater data source – rahularyansharma Jul 30 '12 at 08:37
@rahularyansharma: Yes, because I'm sure in the code you haven't shown use, you're specifying a binding which tries to find a property called HotelArea *within* each value. – Jon Skeet Jul 30 '12 at 08:40
i edited my code to show use of uniqueArea, Please check edited part – rahularyansharma Jul 30 '12 at 08:41
@rahularyansharma: Right - see that `Eval("HotelArea")` bit - that's what's trying to find the `HotelArea` part. By that point you've already got the string; you just need the value itself... – Jon Skeet Jul 30 '12 at 08:44
how can i modify my this clause var uniqueArea =searchresult.Select(m => m.HotelArea).Distinct(); to get HotelArea in datasource so repeater works – rahularyansharma Jul 30 '12 at 08:46
thanks , i got answer from @Serge comment i changed the repeater HTML like this <%#Container.DataItem%> and its works now. I want to know one more thing will distinct treat null as unique element – rahularyansharma Jul 30 '12 at 08:50
@rahularyansharma: Yes, that's a separate value. – Jon Skeet Jul 30 '12 at 09:01

score 1 · Accepted Answer · edited May 23 '17 at 10:34

1

Okay, I've moved my answers here.

Part 1: ASP.NET Repeater bind List<string>

Part 2: Skip null and empty strings:

var uniqueArea =searchresult.Select(m => m.HotelArea).Where(m => !string.IsNullOrEmpty(m)).Distinct();

edited May 23 '17 at 10:34

Community

1
1

answered Jul 30 '12 at 09:42

Sergey Vyacheslavovich Brunov

17,291
7
48
81

Bind distinct data to repeater using linq to object distinct

2 Answers2