Hi guys....
I have a grid with 3 bands.... parent,children and grandchildren.....
What settings do i have to set to get the child and grandchildren to update?
Thanks for the sample... but i am doing exactly this except im using a language that you dont support... is there any grid settings to other than on the band to allow update? could the problem not lie in my bindinsource? somehow i suspect this to be the issue other than a setting in a grid...
Its like the grid is not accepting my changes for the child bands wich leads me to believe that it could be a binding issue...???
Any thoughts and suggestions will be appreciated on this one...
Hello Burmo,
Could you please take a look at the attached sample. There are local database with DataSet and three DataTables with relations. You could load the data, change it and save these changes.
Please let me know if you have any questions. If you think that your scenario if different, please feel free to modify this sample and revert it back to me. I`ll be glad to research it.
Regards
Hi Georgi...
Im using a dataset to populate the grid... in my root band i can make changes to cells no problem... if i try to make changes to the child and grandchild cells its like changes are not commited... as soon as i move out the active cell of the child or grandchild my changes are ignored and the previous value is displayed....??
It seems i have an issue where if i make a change in the child band and i click in another row the change seems to dissapear and the old value seems to display...??? but when i go to the parent row i can make changes in cells and they dont change back to the old values...??
I`m not familiar with your scenario and I`m not sure what you mean with "Update", but if you mean to update your data in your database, then please tell me what is your approach to connect with the database (Are you using TabaleAdapters or EntityDataModel or ...). But nevertheless of your scenario you could try:
Burmo said:I have a grid with 3 bands.... parent,children and grandchildren.....
I suppose that you have three tables in your database. Also maybe you have relation between these tables to represent your hierarchy. If so these tables and relation will be represent in your EntityDataModel. So when you make a changes in the child and grandchild bands you could call AcceptChanges() method of your EntityContainer.
If you are using TableAdapters, then you could call Update()method of your TableAdapter with parameter - DataSet which contains your three tabels and relation.
this.dbItemsTableAdapter.Update(this.testDataSet);
Please let me know if you have any further questions.