Hi all,
I am having difficulty in writing values from bound .NET controls back to a ProDataSet and am hoping that someone on here will have the solution / be able to point me in the correct direction.
Here is a basic example of my problem:
I have a dataset that contains 4 tables, lets call them Table1, Table2, Table3 and Table4 for arguments sake. Each table is a child table of the previous.
Table1 - Parent / Top level table
---- Table 2
---- ---- Table 3
---- ---- ---- Table 4
I have four .NET text boxes bound to 1 field on each of the tables.
When I initially open the program the dataset is filled with data and the four bound controls show the data as expected (they are data bound using a probindingsource). However, when I try to update each field, the two text boxes bound to Table1 and Table2 update correctly, but the two text boxes bound to Table3 and Table4 never update the dataset. I am using the ASSIGN method on the bindingsource to update the dataset. Is there anything I am missing out that is required when updating data in child tables?
I am assuming I am missing out a step in the update process somewhere, and am also assuming that my table, dataset and relation definitions are all perfectly OK, as I can see the correct data in all four text boxes when I initially open the program, and all of the values in the text boxes update correctly when I reposition to different records.
Any help on this will be greatly appreciated
Thanks
Nick
I am having difficulty in writing values from bound .NET controls back to a ProDataSet and am hoping that someone on here will have the solution / be able to point me in the correct direction.
Here is a basic example of my problem:
I have a dataset that contains 4 tables, lets call them Table1, Table2, Table3 and Table4 for arguments sake. Each table is a child table of the previous.
Table1 - Parent / Top level table
---- Table 2
---- ---- Table 3
---- ---- ---- Table 4
I have four .NET text boxes bound to 1 field on each of the tables.
When I initially open the program the dataset is filled with data and the four bound controls show the data as expected (they are data bound using a probindingsource). However, when I try to update each field, the two text boxes bound to Table1 and Table2 update correctly, but the two text boxes bound to Table3 and Table4 never update the dataset. I am using the ASSIGN method on the bindingsource to update the dataset. Is there anything I am missing out that is required when updating data in child tables?
I am assuming I am missing out a step in the update process somewhere, and am also assuming that my table, dataset and relation definitions are all perfectly OK, as I can see the correct data in all four text boxes when I initially open the program, and all of the values in the text boxes update correctly when I reposition to different records.
Any help on this will be greatly appreciated
Thanks
Nick