Re: Dumb question #102

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Cor (non_at_non.com)
Date: 02/08/04 

Date: Sun, 8 Feb 2004 22:25:03 +0100

Hi Martin,

If you do not want the relations, you can choose for the datatable.select
and/or you can use the dataview.rowfilter or even a normal loop throught the
tables, it is on you how to use it.

 Cor

> Sorry guys, everybody seems to be missing the question.
>
> I have a typed DataSet with multiple, related tables and the relationships
> set up. I want to loop through a table, and be able to pull out data from
> the related tables. For example (using the example tables I provided
> originally)
>
> Accounts MR1, Martin, 1, 2
> MR2, David, 2, 3
> MR3, Stephen, 1, 3
>
> Status 1, On Hold
> 2, Trading
> 3, Legal
>
> Controller 2, Bob
> 3, Terry
>
> I want to be able to loop through the Accounts table, pulling out:
>
> MR1, Martin, On Hold, Bob
> MR2, David, Trading, Terry
> MR3, Stephen, On Hold, Terry
>
> I want to do this programatically; how do I loop through the tables
> correctly to pull out this data?
> I can loop through the Accounts table without problem, [foreach (DataRow
row
> in ds.Tables["Accounts"].Rows) {}], but how do I pull the related data
from
> Status and Controller for each row that I process?
>
> Cheers.
>
>

Relevant Pages

  • Re: old fortran construct
    ... Bob explained the arithmetic IF. ... > only the inner loop to cycle while a branch to 5 from the outer loop ... > There may be utilities to do such code conversions for you. ... you to start with legal code. ...
    (comp.lang.fortran)
  • Re: modified PIC control loop
    ... "Terry Given" wrote in message ... In a well tuned loop it eliminates not only the ... > seen/played with which usually involve some sort of controller that varies ... > an offset to add to the integrator output to force saturation, ...
    (sci.electronics.design)
  • Re: VBA Loop until certain cell!
    ... Thanks a lot for your answer Bob, but it still doesn't work and keeps ... cell and look upside until cell B5, ... Loop Until ActiveCell> 0 ...
    (microsoft.public.excel.programming)
  • Re: Simplify a macro
    ... Thank you, Bob. ... I have made some small arrangements, but have still trouble with the loop. ... With your corrections the macro looks like this: ... ' Makro registrert 22.08.2005 av eho ...
    (microsoft.public.excel.programming)
  • Re: Manually building a DS and/or can coalesce handle this?
    ... bob | co1 ... while rowcount < total rows in oldDS ... the company string. ... I loop through and add one row. ...
    (microsoft.public.dotnet.framework.aspnet)