By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,827 Members | 2,195 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,827 IT Pros & Developers. It's quick & easy.

Whats best event for changing related data in child table

P: n/a
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
Jun 15 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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?...6-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" <bd*****@sgiims.com> schreef in bericht
news:eF**************@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

Jun 16 '06 #2

P: n/a
Bob
Thanks Cor I,m going to take a close look at it.
"Cor Ligthert [MVP]" <no************@planet.nl> wrote in message
news:%2****************@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?...6-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" <bd*****@sgiims.com> schreef in bericht
news:eF**************@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


Jun 16 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.