Child Row Count

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
I need to present the count on RunTime in the DataGrid. It doesn't seem to
be working for me.

Brock Allen said:
ds.Tables["Parent"].Rows[0].GetChildRows("MyRelationship").Count

-Brock
DevelopMentor
http://staff.develop.com/ballen


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?
Click to expand...
Click to expand...
 
You'll need to post some code then. I'm not sure what the real problem is.

-Brock
DevelopMentor
http://staff.develop.com/ballen


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

Brock Allen said:
ds.Tables["Parent"].Rows[0].GetChildRows("MyRelationship").Count

-Brock
DevelopMentor
http://staff.develop.com/ballen
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?
Click to expand...
Click to expand...
Click to expand...
 
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.
Brock Allen said:
You'll need to post some code then. I'm not sure what the real problem is.

-Brock
DevelopMentor
http://staff.develop.com/ballen


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

Brock Allen said:
ds.Tables["Parent"].Rows[0].GetChildRows("MyRelationship").Count

-Brock
DevelopMentor
http://staff.develop.com/ballen
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?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top