Inserts in Detail Table

[Daniel]

I have a detail table with a ParentTableRelation setup. The child rows are displaying and filtering for the parent record, I want to be able to add new rows where the newly inserted row includes the ID of the parent into it's forgein key. I had thought that setting up a ParentTableRelation might automatically do this, but saving fails due to the forgein key not being supplied.

Are there any examples of this?

If there's no simple way to do this I could always set a hidden field when the row is created. 

[Martin]

Hello Daniel,

You can use the InsertCommand event to achieve you goal:

protected void RadGrid1_InsertCommand(object source, GridCommandEventArgs e)
{
    // Detect the Detail Table name
    if ("Orders".Equals(e.Item.OwnerTableView.Name))
    {
        // Get the Parent Item in which the Detail Table is placed
        GridDataItem parentItem = (GridDataItem)e.Item.OwnerTableView.ParentItem;
        // Set the DataKeyValue of the parent item as a parameter of the DataSource control
        SqlDataSource2.InsertParameters["CustomerID"].DefaultValue = parentItem.OwnerTableView.DataKeyValues[parentItem.ItemIndex]["CustomerID"].ToString();
    }
}

More information on the matter and a sample runnable demo is available here.

I hope this helps.

Regards,
Martin
the Telerik team