Cannot rebind parent tableview after update

[Wyatt]

I have a grid with a master table and a detail/child table.  Both tables have a balance field.  The master table's balance field is the sum of it child balance fields.  When a child record is updated, I want the parent balance to reflect the change.  When I call Rebind() at the end of the UpdateCommand handler for a detail table, Get the following error.

"There was a problem extracting DataKeyValues from the DataSource. Please ensure that DataKeyNames are specified correctly and all fields specified exist in the DataSource."

I read a few treads related to this error but nothing helped for my particular circumstance.

[Iana Tsolova]

Hi Wyatt,

Could you please canceling the command and then rebinding the grid and see if it makes any difference:

protected void RadGrid1_UpdateCommand(object sender, GridCommandEventArgs e)
{
   //code for database update
   e.Canceled = true;
   (sender as RadGrid).Rebind();
}

Greetings,
Iana
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.

[Wyatt]

The data is refreshed correctly and there is no error.  The only problem is that the edit form stays open.

[Iana Tsolova]

Hello Wyatt,

Please excuse me for misleading you.

Try adding the below line for closing the grid edit form after update:

protected void RadGrid1_UpdateCommand(object sender, GridCommandEventArgs e)
{
   //code for database update
   e.Canceled = true;
   e.Item.Edit = false;
   (sender as RadGrid).Rebind();
}

Let me know if it works for you.

All the best,
Iana
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.

[Wyatt]

That works.  Thank you!

Rebind collapses expansions, so I modified your example to persist expansions.

Protected Sub rgGrid_UpdateCommand(ByVal sender As Object, ByVal e As GridCommandEventArgs) Handles rgGrid.UpdateCommand
    'Perform Update
    e.Canceled = True
    e.Item.Edit = False
    HLWebUtil.ExpandedRebind(sender)
End Sub

Public Shared Sub ExpandedRebind(ByVal Grid As RadGrid)
    Dim KeysExpanded As String() = (From i As GridDataItem In Grid.MasterTableView.Items Where i.Expanded Select i.KeyValues).ToArray
    Grid.Rebind()
    For Each Item As GridDataItem In (From i As GridDataItem In Grid.MasterTableView.Items Where KeysExpanded.Contains(i.KeyValues) Select i).ToArray
        Item.Expanded = True
    Next
End Sub