adoquery1.SQL.Clear; adoquery1.SQL.Add('select distinct(XXX) from XXX'); //进行查询并取行单一值 adoquery1.Open; ADOQuery1.First; for I := 0 to AdoQuery1.RecordCount - 1 do begin combobox1.items.add(adoquery1.fieldbyname('XXX').asstring); //将查询后符合条件的内容datetime放到combobox1 adoquery1.next;放到form的FormCreate里。 end;
同意上面的 adoquery1.SQL.Clear; adoquery1.SQL.Add('select xxx from tablename'); //进行查询并取行adoquery1.Open; combobox1.items.clea; for I := 0 to AdoQuery1.RecordCount - 1 do begin combobox1.items.add(adoquery1.fieldbyname('XXX').asstring); //adoquery1.next;form的FormCreate里。 end;
同意上面的 adoquery1.SQL.Clear; adoquery1.SQL.Add('select xxx from tablename group by(xxx)'); //进行查询并取行adoquery1.Open; combobox1.items.clea; for I := 0 to AdoQuery1.RecordCount - 1 do begin combobox1.items.add(adoquery1.fieldbyname('XXX').asstring); //adoquery1.next;form的FormCreate里。 end;
adoquery1.SQL.Add('select distinct(XXX) from XXX'); //进行查询并取行单一值
adoquery1.Open;
ADOQuery1.First;
for I := 0 to AdoQuery1.RecordCount - 1 do
begin
combobox1.items.add(adoquery1.fieldbyname('XXX').asstring); //将查询后符合条件的内容datetime放到combobox1
adoquery1.next;放到form的FormCreate里。
end;
adoquery1.SQL.Clear;
adoquery1.SQL.Add('select xxx from tablename'); //进行查询并取行adoquery1.Open;
combobox1.items.clea;
for I := 0 to AdoQuery1.RecordCount - 1 do
begin
combobox1.items.add(adoquery1.fieldbyname('XXX').asstring); //adoquery1.next;form的FormCreate里。
end;
adoquery1.SQL.Clear;
adoquery1.SQL.Add('select xxx from tablename group by(xxx)'); //进行查询并取行adoquery1.Open;
combobox1.items.clea;
for I := 0 to AdoQuery1.RecordCount - 1 do
begin
combobox1.items.add(adoquery1.fieldbyname('XXX').asstring); //adoquery1.next;form的FormCreate里。
end;