(another) datarelation datagrid question

i have an ad hoc query builder (long story)
to faciliate ad hoc heterogenious queries (all kinds of databases - linked
servers arent an option)
and i would like the end data displayed in a datagrid without the '+'

in a manner described best by "How to Display Child Table Rows as a Column
in a DataGrid"
http://dotnetjunkies.com/Article/2E3CF274-D5F6-4F43-97C7-805E1A887280.dcik
if i set this up in design time i can add the tables and fields for 2
tables, add the datarelations, create a new datatable, add some columns to it
that i would like bound to the final grid. i loop thru the parent table and
inside that loop i loop thru the child table and add the data from the
appropriate fields to the new dataTable. then i bind to the grid. the grid
look exactly as i want and as a bonus it filters parent records without
matching child fields, all is well.

the next part is making my ears bleed, just a little bit.

i would like to be able to (in run time) programatically walk thru the
tables in the dataset and do the same thing but for as many tables and fields
as are present in the dataset.

any help (or even lighthearted mockery) is appreciated.

in over his head,
gabe

.

Relevant Pages

  • Re: trying to understand fork and wait
    ... old habits based on learning to script in REXX on the ... > the child reads it. ... situation for me (drop through to bottom/go back to top of loop). ... just to keep a hold of the exit code. ...
    (comp.lang.perl.misc)
  • Re: User changing key value
    ... Parent and Child. ... the Child grid. ... After the user has entered a new valid primary key value, ... rows in the Parent grid, and then return to the row with the new key ...
    (microsoft.public.vsnet.general)
  • User changing key value
    ... Parent and Child. ... scrolls through the Parent grid, just the related Child data shows in ... the Child grid. ...
    (microsoft.public.vsnet.general)
  • Re: CurrencyManager Position issue
    ... Our grid is a custom grid, ... But, if we tie the current row to the CurrencyManager, a current row of -1 ... displayed in the child table if the first parent row has child records. ... then you want to be showing a selection in the parent ...
    (microsoft.public.dotnet.framework.windowsforms)
  • Re: Edit Data using MSFlexgrid
    ... Child Form to requery with the Child records linked to the current Parent ... I am using the code in the Fom_Current of the ParentForm, ... If you talking about the very last one, the grid on the left side actually ... I have another grid on the right that display multiple rows from the left ...
    (microsoft.public.access.formscoding)
Loading