Parent and Child grids data relation in Flexgrid

Parent and Child grids data relation in Flexgrid

Posted by: munesh442 on 30 October 2017, 5:04 am EST

• 

  munesh442

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 30 October 2017, 5:04 am EST

  i am developing grid where i have to display data in a hierarchical way.it’s working fine up to the two layers but in the third i have to display two different child tables under the parent row. i have created the below data relations.

  _ds.Relations.Add(“Main Module”, _ds.Tables(0).Columns(0), _ds.Tables(1).Columns(0))

          _ds.Relations.Add("Lines", _ds.Tables(1).Columns(1), _ds.Tables(2).Columns(0))
  
          _ds.Relations.Add("Module_Details", _ds.Tables(2).Columns(1), _ds.Tables(3).Columns(0))
  
          _ds.Relations.Add("Subtotal_Details", ,_ds.Tables(2).Columns(1),_ds.Tables(4).Columns(0))
  

  Table(2) is a parent table and Table(3) and Table(4) are the child tables.

  Relation ‘Module_Details’ working fine but the parent row is not not displaying ‘Subtotal_Details’ even though table has the data.

  Can you please help where i am missing?

• 

  munesh442

  • Post Options:
  • Link
    Copy

  Posted 30 October 2017, 5:06 am EST

  Data displayed in grid

• 

  meenakshi.singh

  

  • Post Options:
  • Link
    Copy

  Posted 31 October 2017, 12:12 pm EST

  Hi!

  It does not seem to be possible directly this way. But, We are working to see if there is any workaround to achieve this behaviour.
  
  We will come back to you soon.

  Regards,
  
  Meenakshi

• 

  sonu.singh

  

  • Post Options:
  • Link
    Copy

  Posted 1 November 2017, 7:41 am EST

  Hi,
  
  In C1FlexGrid, you can binding data sources with hierarchical data relations using custom code. * “-- a way specified by the developer.”

  Please read the Data Binding option at the link below:
  
  http://help.grapecity.com/componentone/NetHelp/c1flexgrid/FeatureComparisonMatrix.html

  For binding a grid to a hierarchical data source and show details in child grids.
  
  You can see the DataTree sample installed at below location and try to implement your requirement using the similar way.
  
  C:..\Documents\ComponentOne Samples\WinForms\C1FlexGrid\CS\DataTree

  Thanks,
  
  Singh