"Bob" <bduf***@sgiims.com> schreef in bericht
news:eFB2Y4LkGHA.1508@TK2MSFTNGP04.phx.gbl...
>I got three related datagrid views one parent and two children of the same.
>The two child tables contain many thousands of records and some of the
>contents are bitmap files in a sql server database. The default behaviour
>of loading all the contents of the parent data table and also all the
>related data is not acceptable, its takes too long to complete. What I need
>to do IMHO, is to load the parent table and after its loaded, and it gets
>positionned on the  first record, only then should I fill in the related
>tables filtered on the primary key of the current parent record. When my
>user moves off a parent record I want to invoke an automatic update. Get to
>the new record and do a fill on the child tables with the new filter for
>the new parent's record primary key.
>
> What are the best events for 1 - after filling the parent table filling
> the current child table records.
> 2- When moving off the parent record, doing an automatic update
> 3- After being positionned on a new parent doing a fill on the related
> child records
>
> Maybe I'm off my rocker and there's an easier way, If so I would
> appreciate knowing about it
>
> Thanks in advance for any help
> Bob
>

"Cor Ligthert [MVP]" <notmyfirstn***@planet.nl> wrote in message
news:%23zGpZkQkGHA.3512@TK2MSFTNGP03.phx.gbl...
> Bob,
>
> In my idea your problem asks for using the currencymanager and when the
> current change use that to do your updates and to refresh the
> childinformation with a fill.
>
> http://www.vb-tips.com/default.aspx?ID=3e6c910e-3c58-4ce7-a626-9cc458453630
>
> For this you need a continuous connection to the database so you can not
> use it on a PDA.
>
> This way is not conform standard demo's they use the relation way, but
> those are seldom about huge databases and work in all situations.
>
> I hope this helps,
>
> Cor
>
>
> "Bob" <bduf***@sgiims.com> schreef in bericht
> news:eFB2Y4LkGHA.1508@TK2MSFTNGP04.phx.gbl...
>>I got three related datagrid views one parent and two children of the
>>same. The two child tables contain many thousands of records and some of
>>the contents are bitmap files in a sql server database. The default
>>behaviour of loading all the contents of the parent data table and also
>>all the related data is not acceptable, its takes too long to complete.
>>What I need to do IMHO, is to load the parent table and after its loaded,
>>and it gets positionned on the  first record, only then should I fill in
>>the related tables filtered on the primary key of the current parent
>>record. When my user moves off a parent record I want to invoke an
>>automatic update. Get to the new record and do a fill on the child tables
>>with the new filter for the new parent's record primary key.
>>
>> What are the best events for 1 - after filling the parent table filling
>> the current child table records.
>> 2- When moving off the parent record, doing an automatic update
>> 3- After being positionned on a new parent doing a fill on the related
>> child records
>>
>> Maybe I'm off my rocker and there's an easier way, If so I would
>> appreciate knowing about it
>>
>> Thanks in advance for any help
>> Bob
>>
>
>