private void GetEQData(DateTime EqDate, string EQLegalEntity) { var HPositionDataRaw = new List <ve_g1position_gqlObject>(); GetEquilendDataFromSource(HPositionDataRaw, EqDate); EQData.Clear(); EQDataLegalEntities.Clear(); //5773 is our Equilend legal Entity PopulateEQDataObject(HPositionDataRaw, EQData, EQLegalEntity); //Populate the ComboBox. It's databound EQDataLegalEntities.AddRange(EQData.Select(x => x.CPTY_LEGAL_ENTITY_ID).Distinct().ToList()); if (EQData.Count == 0) { MessageBox.Show("No Data"); return; } EQData.OrderBy(x => x.CPTY_LEGAL_ENTITY_ID); }