filter on child row

microsoft.public.dotnet.framework.adonet

5 Nov 2006 8:00 PM

sebastian gereck

hello,
i have a problem with filtering in a parent-child relationship.

what i wanna do is to filter the child table and after that filter the
parent to see if the rows in the parent has child rows.

i do that with an expression column ( "count(child.[col]) in the parent
table.
this expression column is not updated when i set a rowfilter for the
childtable.
i've read here that there are problems with expression columns,ok.

i then tried to iterate through the datarows of the parent and compute
the values by myself.
i try to set DataRow parentdatarow.itemarray[x] = count , but this
doesn't work,too.

thanks for help
sebastian