procedure TForm1.FormCreate(Sender: TObject);
var
MyTreeNode1:TTreeNode;
begin
ADOtree.close;
ADOtree.sql.clear;
ADOtree.sql.add('select ID from tbTree order by ID');
ADOtree.Open;
while not ADOtree.Eof do
begin
with treeview1.Items do
begin
MyTreeNode1 := Add(nil,trim(ADOtree.fields[0].asstring));//增加根节点
with ADOchild do
begin
close;
SQL.Clear;
SQL.Add('select name from treeviewtest where ID='''+Trim(ADOtree.Fields[0].asstring)+''''+' order by name');
Active:=true;
Open;
While Not ADOchild.Eof do
begin
treeview1.Items.AddChild(mytreenode1,trim(ADOchild.Fields[0].AsString));
ADOchild.Next;
end;
end;
ADOtree.Next;
end;
end;
end;