In this example, I will show you to select distinct records from list in linq and bind to a combobox in windows application using c# .net.
I want to bind the list of countries to a combobox using c# .net. The linq Distinct() guarantees to remove duplicate records from the List.
private void LoadCountries()
{
var countries = (from c in db.Orders
select new { c.ShipCountry }).Distinct().ToList();
cboCountry.DataSource = countries;
cboCountry.ValueMember = "shipcountry";
cboCountry.DisplayMember = "shipcountry";
}
Post your comments / questions
Recent Article
- How to add two numbers in Android Studio? | Source Code
- FindViewByID returns null in android studio -SOLVED
- Saving changes is not permitted in SQL SERVER - [SOLVED]
- Restore of database failed. File cannot be restored over the existing. -[SOLVED]
- One or more projects in the solution were not loaded correctly in Visual Studio 2019 | FIXED
- How to find Laptop's Battery Health?
- SOLVED-Related Field got invalid lookup: icontains error in Django
- How to enable Search Feature in Django admin?
Related Article