Trying to group by distinct values and add results to a listview

Question

as the title says, I'm trying to group a selection by it's distinct values, and then iterate through the result to populate a listView of checkboxes, my code is below

var checkBoxAdd =
            from sale in saleData
            orderby sale.City.ToList()
            group sale.City by sale.City.Distinct() into cityDistinct
            select cityDistinct;


foreach (House s in checkBoxAdd)
{
    listViewCities.Items.Add(s.City.ToString());
}

I am getting the following error:

Can anyone help me out with this please

What is the type of sale.City, does it implement IComparable? — Eric Beaulieu, Oct 11 '17 at 19:24
You may find your answer here: https://stackoverflow.com/questions/29465104/at-least-one-object-must-implement-icomparable-calling-orderby — fdsafdsafdsafdsafs, Oct 11 '17 at 19:27
Your results are a List>>. The groups is the first list and the last two are the rows and columns of a table. — jdweng, Oct 11 '17 at 19:34

score 0 · Answer 1 · answered Oct 11 '17 at 19:27

0

That is happen because chekBoxAdd contains no House Objects. Your checkBoxAdd is a IEnumerable<IGrouping<IEnumerable<char>, string>>. You're trying to compare House object with IGrouping<IEnumerable<char>, string> element.

answered Oct 11 '17 at 19:27

Renat Baratov

29
3

Trying to group by distinct values and add results to a listview

1 Answers1