We are at a complete loss.

When using VS 2005 data manager, it creates resulting datasets with parent-child relationships right? So, why then when we use datasets created through VS 2005 wizards (that do have relationships), is the relationship and the underlying structure visible, but there is NO DATA from the child tables?

Let me explain. We now have just about every hierarchical grid on the market in a desperate attempt to find a quick way to create hundreds of datasets and examine the child data. These grids should automatically represent hierarchical data through some sort of expansion or drill down (like the datagrid in VS 2003). In every single grid or control, if we create a dataset through VS2005, we can see the child structures, but no child data is fetched.

If we create this dataset manually and add the relationships ourselves, it works perfectly. But, not if we use VS2005 to do the block and tackling for creating these data sources and datasets.

We are convinced the problem is not with the grids, but with datasets created through VS2005. What could we possibly be missing �a configuration of some sort? Or, are these datasets just good for a single table depth?