procedure Thkglf.lpd1DropDown(Sender: TObject); begin lpd1.Items.Clear; with lpdf.adoquery1 do begin close; sql.clear; sql.add('select * from lpd'); open; while not eof do begin lpd1.Items.Add(fieldbyname('lpd').asstring); next; end; end; end;
我是这样写的啊 procedure init(fieldname,tablename:string,cb:tcombobox); var sqlstr: string begin sqlstr:=format('select %s from %s',[fieldname,tablename]); with query do begin close; sql.clear; sql.add(sqlstr); open; while not eof do begin cb.itmes.add(fields[0].asstring); next; end; end;
begin
lpd1.Items.Clear;
with lpdf.adoquery1 do
begin
close;
sql.clear;
sql.add('select * from lpd');
open;
while not eof do
begin
lpd1.Items.Add(fieldbyname('lpd').asstring);
next;
end;
end;
end;
procedure init(fieldname,tablename:string,cb:tcombobox);
var
sqlstr: string
begin
sqlstr:=format('select %s from %s',[fieldname,tablename]);
with query do
begin
close;
sql.clear;
sql.add(sqlstr);
open;
while not eof do
begin
cb.itmes.add(fields[0].asstring);
next;
end;
end;