How to: Change values in a specific column for root nodes

Nov 13, 2018

The following example iterates through root nodes of the Tree List and changes the “Budget” column value for the “Sales and Marketing” department.TreeListColumn instances are used as column identifiers in the TreeListNode.GetDisplayText, TreeListNode.GetValue and TreeListNode.SetValue methods.

C#
VB.NET

csharp

IEnumerator en = treeList1.Nodes.GetEnumerator();
TreeListColumn columnDep = treeList1.Columns["Department"];
TreeListColumn columnBudget = treeList1.Columns["Budget"];
while (en.MoveNext()) {
   TreeListNode childNode = (TreeListNode)en.Current;
   if(childNode.GetDisplayText(columnDep) == "Sales and Marketing") {
      decimal newBudget = (decimal)childNode.GetValue(columnBudget) / 2;
      childNode.SetValue(columnBudget, newBudget);
   }
}

Dim en As IEnumerator = TreeList1.Nodes.GetEnumerator()
Dim ColumnDep As TreeListColumn = TreeList1.Columns("Department")
Dim ColumnBudget As TreeListColumn = TreeList1.Columns("Budget")
While en.MoveNext() = True
   Dim ChildNode As TreeListNode = CType(en.Current, TreeListNode)
   If ChildNode.GetDisplayText(ColumnDep) = "Sales and Marketing" Then
      Dim NewBudget As Decimal = CType(ChildNode.GetValue(ColumnBudget), Decimal) / 2
      ChildNode.SetValue(ColumnBudget, NewBudget)
   End If
End While