Whats best event for changing related data in child table

[Bob]

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]]

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]

Thanks Cor I,m going to take a close look at it.

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