Forums Home / ComponentOne / WinForms Edition
Posted by: Calvin.Craig on 26 September 2018, 6:16 pm EST
Calvin.Craig
Posted 26 September 2018, 6:16 pm EST
After binding a C1FlexGrid to a C1DataSource at design-time and applying a filter via the FlexGrid’s UI at runtime, I would like programmatically to loop through the FlexGrid’s columns and detect for each column if there is only distinct filtered value.
How can I do this efficiently?
meenakshi.singh
Posted 27 September 2018, 7:55 am EST
Hi Calvin!
Can you please explain about the desired outcome? Are you willing to determine about only those rows which have distinct value in each of its column? Or is it, that at least one column should have distinct value for a particular row?
It would be helpful in suggesting you an appropriate workaround for this. It would be better if you can share an image before and after this operation.
Regards,
Meenakshi
meenakshi.singh
Posted 1 October 2018, 3:32 am EST
Hi Calvin!
Apologies for the delay in response.
And as per my understanding (as shown in image section 3), after applying filter on ‘B.O.M. Description’ you want to check if other columns (‘Washer Number’ and ‘B.O.M. Material’) have distinct values in displayed rows like ‘B.O.M. Description’ column.
Currently, the only possible way seems to be this: In AfterFilter event, loop through the columns and check if filter hasn’t been applied on it then compare its values.
In order to check if filter has been applied or not, please use ActiveFilter property of the column.
Hope this helps you.
Regards,
Meenakshi
