to dearmyfriend(Dearmyfriend):为了防止数据重复应该改一下sql语句
with adoquery do
begin
close;
SQL.Clear;
SQL.Add('select distinct 某字段 from tablename');
Open;
end;
if adoquery.recordcount=0 then exit;
Commbobox1.items.clear;
doQuery.first;
for i:=0 to adoquery.recordcount-1 do
begin
Commbobox1.items.add(adoquery.fieldbyname('fieldbyname').asstring);
adoquery.next;
end;
with adoquery do
begin
close;
SQL.Clear;
SQL.Add('Select * from table');
Open;
end;
if adoquery.recordcount=0 then exit;
Commbobox1.items.clear;
doQuery.first;
for i:=0 to adoquery.recordcount-1 do
begin
Commbobox1.items.add(adoquery.fieldbyname('fieldbyname').asstring);
adoquery.next;
end;