TrueDbGrid and C1DataCollectionBindingList

TrueDbGrid and C1DataCollectionBindingList

Posted by: info on 27 January 2023, 12:07 am EST

• 

  info

  • Post Options:
  • Link
    Copy

  Posted 27 January 2023, 12:07 am EST

  Hello,
  
  I’m trying to get TrueDbGrid to work with Lists through C1DataCollectionBindingList.

  I have 3 problems:

  1. Using the filterbar, why is the data not filtered?
  2. If I group by Category, how do I search and expand the added row on the add?
  3. Is the EvalGroupRows row lookup method optimized or is there a better method?

  I attach the test project.

  Thank you, regards, Marco. GrapeCityQuest1.zip

• 

  kartik.dua

  

  • Post Options:
  • Link
    Copy

  Posted 30 January 2023, 12:07 am EST

  Hi Marco,

  We apologize for the delay in response.

  1. Thank you for providing the sample project. We could observe that the filtering in the C1TrueDBGrid does not work when using C1DataCollectionBindingList as the DataSource. We have shared the observation with the development team to get their insights on it. We will let you know the updates as soon as possible.

  We also observed an issue with the data used in the C1TrueDBGrid. We have also reported that to the development team for further investigation.

  2. Please see the updated sample showing how you can expand the group of the newly added row and then select that row.

  Attachment: GrapeCityQuest1_updated.zip

  [Internal Tracking ID: C1WIN-29004, C1WIN-29007]

  Best Regards,

  Kartik

• 

  kartik.dua

  

  • Post Options:
  • Link
    Copy

  Posted 2 February 2023, 10:01 pm EST

  Hi Marco,

  According to the development team, the C1TrueDBGrid lacks its own filtering mechanism. For filtering, this control creates a filter expression and assigns it to its DataSource. Since the C1DataCollectionBindingList does not support filtering, the C1TrueDBGrid cannot utilize this DataSource for filtering.

  As a result, it is a limitation of the C1DataCollectionBindingList.

  Kind Regards,

  Kartik

• 

  kartik.dua

  

  • Post Options:
  • Link
    Copy

  Posted 2 August 2023, 8:34 pm EST

  Hi Marco,

  We are glad to let you know that filtering support has been added to the C1DataCollectionBindingList. Now, you can use the FilterBar to filter the columns of the C1TrueDBGrid bound to a C1DataCollectionBindingList.

  To use this functionality, you will need to install the latest versions of C1TrueDBGrid and C1DataCollectionBindingList

  (https://www.nuget.org/packages/C1.Win.TrueDBGrid/6.0.20232.611)

  (https://www.nuget.org/packages/C1.DataCollection.BindingList/1.0.20232.164)

  Best Regards,
  
  Kartik