> Hi folks,
> I created a  Business layer which comprised of a type dataset with three
> dataTables using the designer in VS 2005. I also created a relation between
> table1 and table2; then I created another relation between table2 and table 3
> using the primary keys.
> In my presentation layer I created a form and added a datagrid to the form.
> After filling the dataTables etc... I set the datasource for the grid. When I
> ran the appl. the grid displayed only table2 and table3, instead of a
> hierachical relationsip beween table1, table2 and table3. Table2 is a child
> of table1 and table3 is a child of table2....
>
> Does anyone have any suggestion??
> Did I miss something???
>
> Thanks in advance for you help
>
> RP

"Carl Prothman" wrote:

> "PR" <P*@discussions.microsoft.com> wrote in message news:CD0A3393-CECF-4F29-8DF8-51C12B0F6B58@microsoft.com...
> >> Hi folks,
> >> I created a  Business layer which comprised of a type dataset with three
> >> dataTables using the designer in VS 2005. I also created a relation between
> >> table1 and table2; then I created another relation between table2 and table 3
> >> using the primary keys.
> >> In my presentation layer I created a form and added a datagrid to the form.
> >> After filling the dataTables etc... I set the datasource for the grid. When I
> >> ran the appl. the grid displayed only table2 and table3, instead of a
> >> hierachical relationsip beween table1, table2 and table3. Table2 is a child
> >> of table1 and table3 is a child of table2....
> >>
> >> Does anyone have any suggestion??
>
> PR,
> Try setting the DataGrid's DataMember property to the name of Table1.
> http://msdn2.microsoft.com/en-us/library/system.windows.forms.datagrid.datamember.aspx
>
> --
>
> Thanks,
> Carl Prothman
> Microsoft ASP.NET MVP
> http://www.CarlProthman