hello,

I got a SQL-Table with some entries belonging state and connection informations in several columns.

I already importet the nodes. Now I'd like to organize
the connections. Have you some hints which way I should choose to reach that?

thanks

thanks,

I beleave, thats enough Information for the moment

Here is a small example:

[code]
Hashtable childToParent = new Hashtable();

SqlCommand cmd = new SqlCommand();
cmd.Connection = conn1;
cmd.CommandType = CommandType.Text;
cmd.CommandText = "SELECT * FROM dbo.TreeNodes";
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
     Box node = fc.CreateBox(0, 0, 40, 30);

     int nodeID = reader.GetInt32(0);
     node.Text = reader.GetString(1);
     int parentID = reader.GetInt32(2);

     node.Tag = nodeID;
     childToParent[nodeID] = parentID;
}

foreach (Box b in fc.Boxes)
{
     if  (!childToParent.ContainsKey(b.Tag))
           continue;

     fc.CreateArrow(
           fc.FindBox(childToParent[b.Tag]), b);
}

TreeLayout tl = new TreeLayout();
tl.Arrange(fc);
[/code]

I hope that helps,
Stoyan