Q: GetChildRows

4 Oct 2006 4:53 PM

G .Net

Hi

A question has just occurred to me.

I can get the child rows in a relationship using GetChildRows. Further, I
can do something like:

For Each child As DataRow In parent.GetChildRows("Relationship1")
......
Next

What I'd like to know is how to return the same rows but sorted in some
manner. For example, in reverse order or sorted by a date field in the child
row.

I know I can get the rows using a Select statement BUT I'm wondering if I
can achieve a "sorting" of the children using the technique above.

Does anybody have any ideas?

G

4 Oct 2006 6:18 PM

Charlie Brown

It depends how your relationships are setup and when you want to sort,
but you can use Table Views to do some of this.

myDataTable.DefaultView.Sort = "ColumnName DESC"

where the Sort expression is similar to what you would use in SQL.

G .Net wrote:
Show quoteHide quote

> Hi
>
> A question has just occurred to me.
>
> I can get the child rows in a relationship using GetChildRows. Further, I
> can do something like:
>
> For Each child As DataRow In parent.GetChildRows("Relationship1")
> .....
> Next
>
> What I'd like to know is how to return the same rows but sorted in some
> manner. For example, in reverse order or sorted by a date field in the child
> row.
>
> I know I can get the rows using a Select statement BUT I'm wondering if I
> can achieve a "sorting" of the children using the technique above.
>
> Does anybody have any ideas?
>
> G

5 Oct 2006 8:49 AM

G .Net

Hi Charlie

I thought your suggestion looked like the solution when I first saw it.
Unfortunately it didn't work :(

Basically, I tried setting the default view of the child table to sort first
on one of its columns. However, the order of the child rows returned in the
code below does not appear to alter for the code below:

For Each child As DataRow In parent.GetChildRows("Relationship1")

Next

Can you be of any further help?

Thanks again

Show quoteHide quote

"Charlie Brown" <cbr***@duclaw.com> wrote in message
news:1159985896.588851.54280@c28g2000cwb.googlegroups.com...
> It depends how your relationships are setup and when you want to sort,
> but you can use Table Views to do some of this.
>
> myDataTable.DefaultView.Sort = "ColumnName DESC"
>
> where the Sort expression is similar to what you would use in SQL.
>
>
> G .Net wrote:
>> Hi
>>
>> A question has just occurred to me.
>>
>> I can get the child rows in a relationship using GetChildRows. Further, I
>> can do something like:
>>
>> For Each child As DataRow In parent.GetChildRows("Relationship1")
>> .....
>> Next
>>
>> What I'd like to know is how to return the same rows but sorted in some
>> manner. For example, in reverse order or sorted by a date field in the
>> child
>> row.
>>
>> I know I can get the rows using a Select statement BUT I'm wondering if I
>> can achieve a "sorting" of the children using the technique above.
>>
>> Does anybody have any ideas?
>>
>> G
>