two datasets (Master-detail) problem

[Agnes]

I got an invheader and invdetail in one datasetl with the foreign key to
link up.
It display in two separate datagrid, now If i only want to insert one
record in invheader, as I process daInv.update()
It warns me that I need to fill invdetail also...
Do I need to create another dataadaptor .dataset for invheader again ??

Thanks

[Cor Ligthert]

Agnes,

Relation questions are always difficult to answer because we do not know on
what places you have set all the relations and explaining it is almost
impossible mostly.

However when you have used the commandbuilder, than probably two
dataadapters is the most simple to use in this kind of operations, otherwise
you have to build the dataadatapter everytime as new, what would mean as
well minimal two different dataadapters. However it depends very much on
your programlogic how you do it.

I hope this helps?

Cor

I got an invheader and invdetail in one datasetl with the foreign key to
link up.
It display in two separate datagrid, now If i only want to insert one
record in invheader, as I process daInv.update()
It warns me that I need to fill invdetail also...
Do I need to create another dataadaptor .dataset for invheader again ??

Thanks

[Agnes]

I should ask my problem in another way. I got serveral textbox, and one
button .As the user input the data and press button, the data should be
displayed in the datagrid.
However, (I check the database, the records is really inserted. but the
datagird got nothing change in run-time)
I did fill(dsInvoice) again , and dgInvoice.tablestyles.clear() , and then
new the tablestyles again.
But it doesn't help ~~~
"Cor Ligthert" <no**********@planet.nl> ¦b¶l¥ó
news:uv**************@tk2msftngp13.phx.gbl ¤¤¼¶¼g...

Agnes,

Relation questions are always difficult to answer because we do not know on what places you have set all the relations and explaining it is almost
impossible mostly.

However when you have used the commandbuilder, than probably two
dataadapters is the most simple to use in this kind of operations, otherwise you have to build the dataadatapter everytime as new, what would mean as
well minimal two different dataadapters. However it depends very much on
your programlogic how you do it.

I hope this helps?

Cor

I got an invheader and invdetail in one datasetl with the foreign key to
link up.
It display in two separate datagrid, now If i only want to insert one
record in invheader, as I process daInv.update()
It warns me that I need to fill invdetail also...
Do I need to create another dataadaptor .dataset for invheader again ??

Thanks

[Agnes]

I think I am too tired .... and did something wrong about my code . I know
where is my problem
Please ignore the question ~~
"Agnes" <ag***@dynamictech.com.hk> ¦b¶l¥ó
news:O5*************@TK2MSFTNGP12.phx.gbl ¤¤¼¶¼g...

I should ask my problem in another way. I got serveral textbox, and one
button .As the user input the data and press button, the data should be
displayed in the datagrid.
However, (I check the database, the records is really inserted. but the
datagird got nothing change in run-time)
I did fill(dsInvoice) again , and dgInvoice.tablestyles.clear() , and then
new the tablestyles again.
But it doesn't help ~~~
"Cor Ligthert" <no**********@planet.nl> ¦b¶l¥ó
news:uv**************@tk2msftngp13.phx.gbl ¤¤¼¶¼g...

Agnes,

Relation questions are always difficult to answer because we do not know

on

what places you have set all the relations and explaining it is almost
impossible mostly.

However when you have used the commandbuilder, than probably two
dataadapters is the most simple to use in this kind of operations,

otherwise

you have to build the dataadatapter everytime as new, what would mean as
well minimal two different dataadapters. However it depends very much on
your programlogic how you do it.

I hope this helps?

Cor

I got an invheader and invdetail in one datasetl with the foreign key to link up.
It display in two separate datagrid, now If i only want to insert one
record in invheader, as I process daInv.update()
It warns me that I need to fill invdetail also...
Do I need to create another dataadaptor .dataset for invheader again ??
Thanks

[Cor Ligthert]

OK can happen to everybody.

:-)

Cor

I think I am too tired .... and did something wrong about my code . I know
where is my problem
Please ignore the question ~~