gridview with childnodes

23 Oct 2006 10:41 PM

jeff.dupont

Ok, I've been all around the web looking for code on how to do this on
..net 2.0 and have not found exactly what I'm looking for. And for the
few examples that I did happen to come across I was unable to get them
to work. So here it is:

I have a webservice that returns a dataset with 3 datatables. For the
purpose of this explanation we'll work with the first two. Table(0)
has a one to many relationship with Table(1)...

Table(0)
ID       -value-        -desc-
1    First        this is the first parent
2    Second        this is the second parent

Table(1)
ID    ParentKey    -value-        -desc-
1    1        FirstChild    this is the first child
2    1        SecondChild    this is the second child
3    2        ThirdChild    this is the third child

I'm trying to get the results to appear in a hierarchal layout like
which follows:

First        this is the first parent
FirstChild    this is the first child
SecondChild    this is the second child

Second        this is the second parent
ThirdChild    this is the third child

I've added a data relation to the dataset for these tables. The xml
in the debugger displays the table(1) results nested within the
table(0) results, so it's working correctly. But I can't get the
results to display in the format above. Any help or info would be
greatly appreciated. Thanks!

Note: table(1) fields do not coincide with those of table(0). In my
real data there are 5 columns in table(0) and 12 columns in table(1)

-Jeff

24 Oct 2006 4:17 PM

Mark Nelson

Jeff,

It's not possible in Microsoft's GridView Control. It does not support
displaying the information containg some hierarchy (basically some
parent-to-child) relationship.
I've tried doing this Micosoft's Gridview but in vain.
I'm aware of product called Infragistics, whcih can help you
for such kind of rich UI. Infragistics has a control called UltraGrid, that
suffices your needs.

Pls refer the following for more details
http://www.infragistics.com/

--
Thanks & Regards,
Mark Nelson

Show quote

"jeff.dup***@gmail.com" wrote:

> Ok, I've been all around the web looking for code on how to do this on
> ..net 2.0 and have not found exactly what I'm looking for. And for the
> few examples that I did happen to come across I was unable to get them
> to work. So here it is:
>
> I have a webservice that returns a dataset with 3 datatables. For the
> purpose of this explanation we'll work with the first two. Table(0)
> has a one to many relationship with Table(1)...
>
> Table(0)
> ID       -value-        -desc-
> 1    First        this is the first parent
> 2    Second        this is the second parent
>
> Table(1)
> ID    ParentKey    -value-        -desc-
> 1    1        FirstChild    this is the first child
> 2    1        SecondChild    this is the second child
> 3    2        ThirdChild    this is the third child
>
> I'm trying to get the results to appear in a hierarchal layout like
> which follows:
>
> First        this is the first parent
> FirstChild    this is the first child
> SecondChild    this is the second child
>
> Second        this is the second parent
> ThirdChild    this is the third child
>
> I've added a data relation to the dataset for these tables. The xml
> in the debugger displays the table(1) results nested within the
> table(0) results, so it's working correctly. But I can't get the
> results to display in the format above. Any help or info would be
> greatly appreciated. Thanks!
>
> Note: table(1) fields do not coincide with those of table(0). In my
> real data there are 5 columns in table(0) and 12 columns in table(1)
>
> -Jeff
>
>