True - I was just asking a related question. Sorry - I should have made
that more clear.
And I think I've answered it. As far as I can tell
DataRowView.CreateChildView does exactly what I was interested in:
DataView tableView = new DataView(orderTable);
DataView relatedChildren = tableView
many-to-one is
possible.
-Original Message-
From: Moderated discussion of advanced .NET topics.
[mailto:[EMAIL PROTECTED]] On Behalf Of Ben
Kloosterman
Sent: Friday, June 21, 2002 11:52 AM
To: [EMAIL PROTECTED]
Subject: Re: [ADVANCED-DOTNET] Filtering DataSets
Yes I agree with Ian ,
but
> -Original Message-
> From: Ian Griffiths [mailto:[EMAIL PROTECTED]]
> I can see how I can use this when there is just 1 row in the
> child table corresponding to a row in the parent table. But
> what if there are many? For example, support my parent table
> is Orders and my child table
Original Message-
> From: Beauchemin, Bob [mailto:[EMAIL PROTECTED]]
> Sent: 20 June 2002 00:41
> To: [EMAIL PROTECTED]
> Subject: Re: [ADVANCED-DOTNET] Filtering DataSets
>
>
> If you actually have both DataTables in the DataSet already,
> you could add a relationship
nal Message-
> From: Alexander, William [mailto:[EMAIL PROTECTED]]
> Sent: 19 June 2002 22:03
> To: [EMAIL PROTECTED]
> Subject: Re: [ADVANCED-DOTNET] Filtering DataSets
>
>
> You can create a relationship between DataTables in a DataSet
> which will allow you to do this
titleauthor b where
a.au_id = b.au_id
Hope this helps,
Bob Beauchemin
[EMAIL PROTECTED]
-Original Message-
From: Griffiths, Ian
Sent: Thursday, June 20, 2002 1:54 PM
To: [EMAIL PROTECTED]
Subject: Re: [ADVANCED-DOTNET] Filtering DataSets
I can see how I can use this when there is j
Ian Griffiths stated:
> I can see how I can use this when there is just 1 row in the child table
> corresponding to a row in the parent table. But what if there are many?
> For example, support my parent table is Orders and my child table is Order
> Details - I don't see how I can use the expres
:[EMAIL PROTECTED]]On Behalf Of Ian Griffiths
Sent: Friday, 21 June 2002 4:54 AM
To: [EMAIL PROTECTED]
Subject: Re: [ADVANCED-DOTNET] Filtering DataSets
I can see how I can use this when there is just 1 row in the child table
corresponding to a row in the parent table. But what if there are many
I can see how I can use this when there is just 1 row in the child table
corresponding to a row in the parent table. But what if there are many?
For example, support my parent table is Orders and my child table is Order
Details - I don't see how I can use the expression language to do this. Or
i
If you actually have both DataTables in the DataSet already, you could add a
relationship between the DataTables, and use the DataSet Expression language, using
the Parent and/or Child referencing syntax.
The Expression language is doc'd under the class library docs, under
System.Data.DataColu
You can create a relationship between DataTables in a DataSet which will
allow you to do this.
Here is the help file entry about this...
In a DataSet that contains multiple DataTable objects, you can use
DataRelation objects to relate one table to another, to navigate through the
tables, and to
11 matches
Mail list logo
