Use DataRelation to find a parent record without a child record?

[dduva]

Can I use a DataRelation to find out which parent records in Table A do not have a child record in Table B? Or is there some other way to do this?

 

[SHelton]

The following returns an array of datarows where the row in the parent table (table at index 0 in a dataset called ds) has no children in the table referenced in the data relation called Relation_Name.

DataRow[] dr = ds.Tables[0].Select("COUNT(Child(Relation_Name).ColumnName) = 0");

 

[SHelton]

Ooops, sorry. Didn't notice which forum I was in....

Dim dr() As DataRow = ds.Tables(0).Select("COUNT(Child(Relation_Name).ColumnName) = 0")