Master Detail Grid

[HCastilloParticipant]

Hi,
I did a master detail with 2 grids and they work as expected. But I have a question.
How do you do updates in the detail grid and keep the changes?
When I click the first row of the master and make changes to the record in the detail grid, then I click the second row of the master and then again I go back to the first row. When I look at the detail records that belong to the line 1 of the master they are back to their original values. The only option right now is refreshing the whole web page, that means a round trip to the server to get the data. Let me be clear, the updaterow is working great and doing what it should do. My only concern is about the detail grid loosing the changes when you move the focus on the master to another record.

Thank you for your time,

Harold.

[ivailoParticipant]

Hi HCastillo,

You can use the data adapter’s dataBind() method to update grid’s data, instead of refreshing the whole page.

Best Regards,
Ivailo Ivanov

jQWidgets Team
http://www.jqwidgets.com

[HCastilloParticipant]

Thank you Ivailo for your response.
I did it and it works, but the point is now the databind() is pulling all the records for the detail just because I updated one.
Is my reasoning correct?
If this is the case that means receiving over 5,000 records from SQL Server every time I update one on the detail.
I was hoping a different solution. Like the data Adapters exchanging information between each other when one gets and update.
Something that will run local without the trip to the server.

Harold.

[ivailoParticipant]

Hi HCastillo,

In this case, you can load your server data in grid’s initialization and also store it in a local variable.
Then the local changes will be updated in this local variable. You can use it in the details grid binding.

Best Regards,
Ivailo Ivanov

jQWidgets Team
http://www.jqwidgets.com

[Author]

Posts