Need a sample for Master Detail Grid.

[Ravi]

Hi,

Can you please provide a sample program to implement master detail grid which covers the following scenarios.

1)The Master grid should contains static data which should be loaded for the first time during form load.
2)The detail grid should be an editable grid where add, update, delete feature for rows should be possible. The detail grid should always get the data from the database base on the selected master row.
3)Whenever a row is changed(current row) in master grid only the changes(add, update, delete row) in the detail grid should be commited in the database.
4)The detail grid should display the new values from the database based on the new row in master grid.

Regards,
Ravi.

[haneefm]

Hi Ravi,

Essential Grid’s GridGroupingControl supports hierarchical datasets. In the HierarchySample, you will see 5 levels of relations being represented with each level having its own nested table. When a user changes the foreign key value of a record in a nested table, the GridGroupingControl will automatically move the record to its new parent table and scroll the table into view.

Here is a path.
C:\Program Files\Syncfusion\Essential Studio\4.4.0.49\Windows\Grid.Grouping.Windows\Samples\FeatureSamples\HierarchySample

Best regards,
Haneef

[Ravi]

Hi Haneef,

Can i accomplish the task without using GridGrouping Control. I have a limitation of using GridGrouping control at this stage.

Regards,
Ravi.

[haneefm]

Hi Ravi,

You can use the Essential Grid's GridDataBoundGrid control to show the hierarchical dataset. Please refer to the Hierarchical category sample for more details.

Here is a path.
C:\Program Files\Syncfusion\Essential Studio\4.4.0.49\Windows\Grid.Windows\Samples\DataBound\Hierarchical

Best regards,
Haneef