Displaying Hierarchal Data from a Dataset Created in VS 2005

[Michael]

Creating Hierarchal Displaying Grid

We created a dataset with several relationships in VS2005’s through its data source management screens. We would like to get the grid to automatically support this hierarchal data. Silly us, we thought that just binding the grid to the dataset would take care of this. Of course, this results in either an empty grid or just the top most table of the relationship.

The only examples of invoking grids with hierarchal displays involved manually created dataset with several lines of highly involved code to create the relationships. Is it possible without complex code to just take the dataset created by VS 2005 and apply it to the grid such that there is a hierarchal display of the data within the set?

[Administrator]

Hi Michael,

By Default ,GroupingGrid /GridDataboundGrid support the hierarchal data in a dataset.Please refer the Syncfusion Browser Samples that are shipped with the Product.

Here is a path for browser sample.
GroupingGrid : Syncfusion\Essential Studio\4.1.0.62\windows\Grid.Grouping.Windows\Samples\HierarchySample\cs
GridDataBoundGrid ( refer the Hierarchical Category ): \Syncfusion\Essential Studio\4.1.0.62\windows\Grid.Windows\Samples\DataBound\Hierarchical\

Let us know if this helps.
Regards,
Haneef

[Administrator]

Well, it helped a bit. I had been using the data bound grid, yet it never displayed any resemblance of recognizing child tables within my dataset. The data bound grid example does not help if I am not creating my own classes.

I had not thought about the grouping data bound grid, so this got me a step closer. I am able to get this control to at least recognize there are child tables in my dataset, but it never retrieves the data for the child tables. From this point, your examples do not help because you had code your own data and data sets.

My goal was to have a very - very simple method of creating datasets through VS2005 and connecting a grid so that I can examine data. So now if I get child subsets without records, is the problem in the dataset or how I configuration the grid to use the dataset? I can see the relationship in the dataset and I can see that the relationship is correct.

>Hi Michael,
>
>By Default ,GroupingGrid /GridDataboundGrid support the hierarchal data in a dataset.Please refer the Syncfusion Browser Samples that are shipped with the Product.
>
>Here is a path for browser sample.
>GroupingGrid : Syncfusion\Essential Studio\4.1.0.62\windows\Grid.Grouping.Windows\Samples\HierarchySample\cs
>GridDataBoundGrid ( refer the Hierarchical Category ): \Syncfusion\Essential Studio\4.1.0.62\windows\Grid.Windows\Samples\DataBound\Hierarchical\
>
>Let us know if this helps.
>Regards,
>Haneef
>

[Administrator]

Hi,

There is no build-in support for getting the child table directly in a GridDataBoundGrid. You need to use GridGroupingControl if you need this feature.Please refer the attached sample for more details.

Here is a sample.
http://www.syncfusion.com/Support/user/uploads/GetNestedTableValue_2338c2ee.zip

here is sample for DataBoundGrid''s Master-child relation sample
http://www.syncfusion.com/Support/user/uploads/MasterDetails_5d11f263.zip

Please let me know if this helps.
Regards,
Haneef

[Michael]

Haneef,

I really appreciate your assistance. I really don''t care which grid or control I use. I have attempted to use the grouping control.

I created a dataset through VS2005 (not manually created through code). I get the data set connected to the grouping control alright. The control recognizes there are tables in the parent-child relationship. And, I believe it recognizes this relationship correctly. The grouping control seems to show the child tables properly attached parent table.

So far so good, however, when I actually run the application there is NO data for the child tables as related to a specific parent record. In fact, there appears to be no child data anywhere. It is as if a fetch is not happening somewhere.

[Administrator]

Hi Micheal,

We tried to reproduce this issue here, but could not get this issue. Maybe I am not following the steps that you are doing. Attached sample working fine here. Can you post a sample showing this problem or tell us how to see it in the Browser sample/attached sample?

Here is a sample.
http://www.syncfusion.com/Support/user/uploads/DesignDataGrid_215c5c65.zip

Please let us know ,if you have any more questions.

Thanks for choosing Syncfusion Products
Regards,
Haneef