Child Row Count

[Guest]

I have two tables pluged into a dataRelation Collection and I need to get the
count of rows in the child table. Anyone have ideas on how I can accomplish
this?

 

[Brock Allen]

ds.Tables["Parent"].Rows[0].GetChildRows("MyRelationship").Count

 

[Guest]

I need to present the count on RunTime in the DataGrid. It doesn't seem to
be working for me.

ds.Tables["Parent"].Rows[0].GetChildRows("MyRelationship").Count

I have two tables pluged into a dataRelation Collection and I need to
get the count of rows in the child table. Anyone have ideas on how I
can accomplish this?

 

[Brock Allen]

You'll need to post some code then. I'm not sure what the real problem is.

I need to present the count on RunTime in the DataGrid. It doesn't
seem to be working for me.

ds.Tables["Parent"].Rows[0].GetChildRows("MyRelationship").Count

I have two tables pluged into a dataRelation Collection and I need
to get the count of rows in the child table. Anyone have ideas on
how I can accomplish this?

 

[Guest]

No worries Brock thank you for replying. I figured it out by adding a new
column in the DataTable that calculated the aggregate number of Child rows;
as follows:

// DataRelation Item.
// then I created the new column "NumberofImgs":

dsClub.Tables["EVNR"].Columns.Add("NumberofImgs",typeof(Double),"Count(Child(EVNR_IMG).EVNRID)");

I then bound the new column to the datagrid.

It seems clean and works fine.

You'll need to post some code then. I'm not sure what the real problem is.

I need to present the count on RunTime in the DataGrid. It doesn't
seem to be working for me.

ds.Tables["Parent"].Rows[0].GetChildRows("MyRelationship").Count


I have two tables pluged into a dataRelation Collection and I need
to get the count of rows in the child table. Anyone have ideas on
how I can accomplish this?