How to set different childtable

[zhheng]

how to set different childtable
require:
1.childtable have different column ,and have different cell type.
2,ParentTable's data must come from DataTable,not come from SQL
3,childtable's data must come from DataTable,not come from SQL.
And ,the different childtable must hvae differnt DataTable.
for example :
childTalbe1: name number age
Jack 1 24
Rose 2 23
Jime 3 26
childTable2: Animal high weight number
dog 1.11 20 1
mokey 2.22 30 2
cow 3.33 30 3
thanks!

[Jisha Joy]

Hi,

You could refer the following sample from the sample browser to achieve the desired behavior.

C:\Syncfusion\8.2.0.30\Windows\Grid.Windows\Samples\2.0\Data Bound\GDBG Drop Grid Demo

This sample displays hierarchical data using nested drop grids. To specify a relationship between a parent table and a child table, you must pass an event handler for the event QueryFilterString. Your event should specify the FilterString that defines the relationship between the parent table and the child table.

Please try this and let me know if this helps.

Jisha

[zhheng]

sorry, that demo is hard to find what i need .so ,can you tell me a simple demo.And ,request: useing GridGroupinControl, several different datatables ,not use something about XSD file,not use something about SQL.

please hurry up!
thank you very much!!!

[Jisha Joy]

Hi,

By default it is not possible to have different child tables of parent rows. One thing you could achieve the desired behavior by establishing multiple relations from parent to child and hide the unnecssary tables from the parent row.

The ChildTable can be made hidden when it has no records to show up, by using a CustomEngine. Also you need to handle QueryCellStyleInfo event of the GridGroupiingControl to hide the +/- sign. Please refer the following KB article that shows how to hide the ChildTable that doesn't have any records to show up in GridGroupingControl.

KB link:

http://www.syncfusion.com/support/kb/721/How-to-hide-the-ChildTable-that-doesn

Please use the following link for the sample:

http://help.syncfusion.com/samples/kb/grid.windows/GGCHideEmptyChildTable/main.htm


Regards,
Jisha