Get Distinct property values from List

0 Answers

I think you can use different approaches here:

  1. Make Sql query that queries distinct values.

  2. Check that contact already in list. This approach assume that your class must redefine euqality operator. Or you can check that this contact id is already in list.

  3. Use Linq query as mentioned above.


I am trying to get distinct FullNames from a list that contains FullNames and IDs then displaying these in a listBox control. Is there a simple way to do it? Thanks Ben

using (DB2DataReader dr = command.ExecuteReader())
                while (dr.Read())

                Contact contact = new Contact();

                contact.ContactID = Convert.ToInt32(dr["CONTACT_ID"]);
                contact.FullName= dr["FULL_NAME"].ToString();


                //contactsListBox.ItemsSource = myContacts.Distinct FullName??