[Solved] update/insert data for the child/details Table of the hierarchical grid.

[newbie]

Hi I am trying to update/insert/delete data in the a heirarchical grid from code behind.

I am checking for the dataMember currently to update/insert/delete respectively from master/detail grid.

protected

void myGrid_DeleteCommand(object source, GridCommandEventArgs e)
{

if

(e.Item.OwnerTableView.DataMember == "Orders")
{

DataRow[] deleteRow = AssignmentRailItemDS.Tables["Orders"].Select("OrderID = " + e.Item.OwnerTableView.DataKeyValues[e.Item.ItemIndex]["OrderID"]);
deleteRow[0].Delete();

}

else if (e.Item.OwnerTableView.DataMember == "Products")
{

DataRow[] deleteChildRow = AssignmentRailItemDS.Tables["Products"].Select("ProductID = " + e.Item.OwnerTableView.DataKeyValues[e.Item.ItemIndex]["ProductID"]);
deleteChildRow[0].Delete();

}

}

Is this the right approach?
Can I have a working example of the insert/delete operations?

[Shinu]

Hi Newbie,

Check out the online demo given below.
Update/Insert/Delete in hierarchy

Thanks
Shinu.

[newbie]

Thanks for the response.
But the example mentioned ues automaic operations
I want to do it from my code behind. Can I have an example of that.