How can I generate treeview nodes programmatically for this collection
node id parent node id
------- --------------
100 null //this is the root node
101 100
123 101
124 101
126 101
103 100
104 100
109 100
128 109
122 100
127 122
129 127
130 129
Here's an example in VB.NET which can be translated to C# and adapted to your scenario.
Here is some pseudo-code that might help to get you started
AddChildNodes(TreeNode parentNode)
{
var childNodeIds GetChildNodeIds(parentNode.Id);
foreach (int childNodeId in childNodeIds)
{
TreeNode childNode = new TreeNode();
//set other properties...
//add to parent
parentNode.Nodes.Add(childNode);
//call same function recursively
AddChildNodes(childNode);
}
}
Then in your program you get started by getting all items without parent node id (root nodes), creating a node for them and then calling the recursive function above.