下面是一段我设计目录树的代码,其中建了两个表。估计对楼主有帮助。
procedure Tfzjm.FormShow(Sender: TObject);
var
str,str1,str2:string ;
begin
treeview1.Items.Clear;
str2:='''' ;
with adoquery1 do
begin
close;
sql.clear;
sql.Add('select distinct ml from ml');
open;
end;
adoquery1.first;
while not adoquery1.eof do
begin
node2:=treeview1.items.add(node1,adoquery1.fieldbyname('ml').asstring);
str1:=adoquery1.fieldbyname('ml').asstring ;
with adoquery2 do
begin
close;
sql.clear;
str:= 'select * from treeview where ml='+str2+str1+str2 ;
sql.add(str);
open;
end;
adoquery2.first;
while not adoquery2.eof do
begin
treeview1.items.addchildfirst(node2,adoquery2.fieldbyname('mm').asstring);
adoquery2.next;
end;
adoquery1.next;
end;
end;