C1FlexGrid large combo box performance

C1FlexGrid large combo box performance

Posted by: hdle on 3 December 2021, 5:23 pm EST

• 

  hdle

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 3 December 2021, 5:23 pm EST

  Hi,

  I am looking for ways to improve my DataMapped Combobox column. There are 20,000 selectable items for that column (I know it’s too large for a Combobox). However, the selectable options depend on the selected type in another column. Assume a two columns grid:
  
  [Vehicle Type][Vehicle]

  The user selects a vehicle type first, then a vehicle. I used the SetupEditor to limit the combo box to just vehicles of the selected type. However, this still takes too long because the Combobox object is already created with 20K items prior to SetupEditor being called.

  If I limited the vehicle using StartEdit and change the DataMap entry, then it will mess up other rows because the selected vehicle is not on the DataMap list.

  Is there a way to control the list prior to the Combobox being created?

  Thanks,
  
  Hai

• 

  avnish.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 6 December 2021, 7:52 am EST

  Hello Hai,

  You can use a ComboBox as the Editor for the Vehicle Column and populate the ComboBox with only the values corresponding to the VehicleType selected, in the SetupEditor event.
  
  You can set the DisplayMember and ValueMember properties of the ComboBox to show translated values in the Vehicle dropdown.
  
  Kindly refer to the attached sample showing the same.
  
  Please let us know if you need any other information.

  Regards,
  
  Avnish

  FlexGrid_DatamapLarge.zip

• 

  hdle

  • Post Options:
  • Link
    Copy

  Posted 6 December 2021, 11:58 am EST

  Hello Avnish,

  The solution you provided seems to work for my needs.
  
  Thank you for your help!

  Hai