getting child DataTable from relation

From: Randy Danielson (no_freakin_spam_at_sickofit.com)
Date: 07/20/04 

Date: Tue, 20 Jul 2004 07:56:13 -0700

Hello,

I have a dataset with two tables. Table 1 is parent to table 2 and
these two tables are related with a DataRelation.

I would like to get the child records in a DataTable so I could use the
DataTable as the DataSource for a DataGrid, but GetChildRows returns an
array of DataRows not a DataTable.

Is there an easy way or will I need to use something other than a
relation like a filter?

Thanks

Randy

Relevant Pages

  • Child Aggregate Filter Not Recognising Newly Added Child Rows (ADO.NET 2.0 Dataset)
    ... reflect in any aggregate filter placed upon the parent table. ... Public Sub FillParent() ... (i.e. the filter does not recognise the new child rows). ...
    (microsoft.public.dotnet.framework.adonet)
  • How to sort a DataGrid bound to a DataRelation?
    ... DataRelation defining the parent-child relationship between them. ... form, there is a DropDownList ComboBox bound to the parent table, ... rows from the child table. ... I can't use a DataView because ...
    (microsoft.public.dotnet.framework.windowsforms.databinding)
  • Re: GetParentRow(s) or GetChildRows?
    ... Orders & Order Details. ... Which table would you expect to be the Parent? ... Which table would you expect to be the Child? ... > Creates a DataRelation with a specified parent and child column, ...
    (microsoft.public.dotnet.general)
  • Re: Still trying to clear cobwebs...
    ... Almost forgot a key detail The criteria I'd like to filter ... on is not in the child table, but in another related table that is M:1 to ... >field to bind the parent to. ...
    (comp.databases.paradox)
  • Re: Filtering and Parent-Child Relation
    ... I had one filter that on a Parent Table that the filter was depending ... on the Child of that table. ... and a child table called AccountRoutes with also 2 columns AccountID ...
    (microsoft.public.sqlserver.replication)