Flexgrid MultiColumnDictionary questions

Flexgrid MultiColumnDictionary questions

Posted by: russ.lunn on 5 April 2023, 9:21 am EST

• 

  russ.lunn

  • Post Options:
  • Link
    Copy

  Posted 5 April 2023, 9:21 am EST

  HI,

  I have a MultiColumnDictionary set as the data map for a column.
  
  it works fine, but I would like to be able to filter the rows based on the user typing.
  
  like autosuggest. also , it would be good to filter the results based on a value in a different column. so if I show code, description, category as the columns. being able to filter the available selection to only show items in the selected category.
  
  this would be while the multicolumn combo is visible on screen. is that possible?

• 

  kartik.dua

  

  • Post Options:
  • Link
    Copy

  Posted 6 April 2023, 6:07 am EST

  Hi Russ,

  (1) To filter the rows of the multi-column combo based on the value of another column, you can use a DataTable as the DataSource for the MultiColumnDictionary. Then, in the StartEdit event of the C1FlexGrid, you can apply a RowFilter to the DataTable.DefaultView using the value of that other column.

  (2) In the SetupEditor event of the C1FlexGrid, you can get the multi-column ComboBox and set its DropDownStyle to DropDown. This way, the user will be able to type in the dropdown editor and will get AutoComplete suggestions from the Key column of the MultiColumnDictionary.

  Please see the attached sample project for reference. The attached zip also includes a video showing both the features we explained above.

  Attachment: FlexGrid.MultiColDict.zip

  Best Regards,

  Kartik