Risisditync
New Member
I have Country/Facility drop-down (multiselect checklistbox). I have Facility and Country in same table. I was able to populate the Country and Facility independently, but not able make them cascade.\[code\]var faci = value.Select(n => new { n.FacilityId, n.FacilityCountry }) .Where(p => p.FacilityCountry.All(x => selectedCountries.Contains(x.ToString()))); \[/code\]Now I wanted to check on three questions:[*]If I have to select distinct countries, how can I bind \[code\]faciId\[/code\] and\[code\]CountryName\[/code\] to chklst? I get only \[code\]CountryName\[/code\] if I do:\[code\]n=>n.FacitliyCountry).Distinct();//.Select(r=>r.FacitliyCountry).Distinct();\[/code\][*]What event should I handle for chklstbox so I dont fill the facility every time user checks/un-checks country?[*]How does selectMany /select work once you select multiple items from the country list?I really appreciate any input which can push me in right direction.