Q: GetChildRows

[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

[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:

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

[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
"Charlie Brown" <cb****@duclaw.comwrote in message
news:11*********************@c28g2000cwb.googlegro ups.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