filtering dataview where child relation does not exist

  • Thread starter Thread starter lars
  • Start date Start date
L

lars

Hi,
Theoretically this seems a simple thing but...can anyone help on how to do it?

I have two tables and a relationship between them.
The parent table is databound to a repeater
the Child table is databound to a nested repeater.

All is well and the data displays.

However, some parent records do not have child records. I would like the repeater not to show these parent records that have no child. Basically, do not show the title if no items exist. This is proving difficult.

I had hoped that either the repeater itself or a Dataview would be able to facilitate this. But alas, I am at a loss. Can anyone help? Thanks



From http://www.developmentnow.com/g/7_2004_2_0_0_0/dotnet-framework-adonet.htm

Posted via DevelopmentNow.com Groups
http://www.developmentnow.com
 
Hi,

I would try to use DataView and its RowFilter property set to one of the
aggregate function (Count > 0) perhaps.
 
Back
Top