procedure TForm1.FormShow(Sender: TObject); begin ADOQuery1.Close; ADOQuery1.Sql.Clear; ADOQuery1.SQL.Add('select * from tablename'); ADOQuery1.Open; while not ADOQuery1.eof do begin ComboBox1.Items.Add(ADOQuery1.FIeldByName('Name').AsString)' ADOQuery1.Next; end; end;
DBLookupComboBox的ListField绑定你要显示的字段即可
用combobox实现 : ADOQuery1.Close; ADOQuery1.SQL.Clear; ADOQuery1.SQL.Add('select name from table'); adoquery1.open; while not adoquery1.eof do begin combobox1.items.add(adoquery1.fieldbyname('name').value); adoquery1.next; end;
begin
DBComboBox1.DataSource := DataSource1;
DataSource1.DataSet := ADOQuery1;
...
ADOQuery1.SQL.Add('select * from tablename');
ADOQuery1.Open;
DBComboBox1.DataField := 'name';
DBComboBox1.Refresh;
end;
begin
ADOQuery1.Close;
ADOQuery1.Sql.Clear;
ADOQuery1.SQL.Add('select * from tablename');
ADOQuery1.Open;
while not ADOQuery1.eof do
begin
ComboBox1.Items.Add(ADOQuery1.FIeldByName('Name').AsString)'
ADOQuery1.Next;
end;
end;
ADOQuery1.Close;
ADOQuery1.SQL.Clear;
ADOQuery1.SQL.Add('select name from table');
adoquery1.open;
while not adoquery1.eof do
begin
combobox1.items.add(adoquery1.fieldbyname('name').value);
adoquery1.next;
end;