Replied 8 September 2017, 2:22 pm EST
After Expanding all the children of parent Node we can edit it and then On Click of Save button, if you have your Spread control bound to the hierarchial dataset, then when you query the DataSource property of the Spread, you would get the entire DataSet. You should be able to go through the DataTables in the DataSet to get all the changes and write them back. Or, if you are using an adapter (SQLDataAdapter or OLEDBDataAdapter), you should be able to update the entire DataSet with one call to the Update method using EndEdit() which pushes changes since the last BeginEdit or AddNew call into the underlying object.
Then to close all the nodes after saving in database you can call the below given code on a click of a button:
private void btnCloseAll_Click(object sender, EventArgs e)
for (int i = 0; i < fpSpread1.ActiveSheet.Rows.Count - 1; i++)
b = fpSpread1.ActiveSheet.IsRowExpanded(i);
if (b == true)
Hope this will help you. Thanks.