I have a Web Grid with two bands bound to a DataSet. When an update happens to row in the parent band, I need to change data in the rows in the child band. Likewise, when a child row changes, the row in the parent band needs to be updated. I found I can set the LoadOnDemand to LoadOnDemand.Manual, but the entire Grid refreshes with every update. I like the preformance of LoadOnDemand.Automatic, but it only refreshes the row where the update happened during a DataBind, not the related rows.

Is there a way to specify which rows should be changed on the grid using LoadOnDemand.Automatic or LoadOnDemand.Manual instead of refreshing the entire grid?