filtering dataview where child relation does not exist

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
 
M

Miha Markic [MVP C#]

Hi,

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Parent-Child-Relation and DataView - .net 2.0 3
How to apply filtering to a child table in a parent/child grid 1
Limit rows in a DataView to those used in a relation with RowFilter? 0
Parent Child grandchild relation problems 2
Filter on Parent-child relation?? 1
Filter on child row column 7
Filter Master Table based on Child Criteria 3
insert parent-child rows with transaction 1

Top