with adoquery1 do begin Close; Sql.Clear(); Sql.Add('select * from tabel1'); Open; combobox1.items.clear; First; while not eof do begin combobox1.items.add(FieldbyName('name').asstring); next; end; end;
tmpQuery := TADOQuery.Create(self); tmpQuery.Connection := FADOCon; tmpQuery.Close; tmpQuery.SQL.Clear; tmpQuery.SQL.Add('SELECT DISTINCT 用户名 FROM login_user;'); tmpQuery.Open; ComboBox1.Items.Clear; tmpQuery.First; while not tmpQuery.Eof do begin if length(trim(tmpQuery.Fields[0].AsString)) > 0 then ComboBox1.Items.Add(tmpQuery.Fields[0].AsString); tmpQuery.Next; end; tmpQuery.Free;
with adoquery1 do begin Close; Sql.Clear(); Sql.Add('select name from tabel1'); Open; combobox1.items.clear; First; while not eof do begin combobox1.items.add(FieldbyName('name').asstring); next; end; end;
然后combobox.items.add(adoquery.filebyname('用户名').asstring)
就可以了
那麼, 如果不多的話,
打開一個dataSet, 然後, 從頭到尾 依次加到 combobox.items 應該就可吧!
begin
Close;
Sql.Clear();
Sql.Add('select * from tabel1');
Open;
combobox1.items.clear;
First;
while not eof do
begin
combobox1.items.add(FieldbyName('name').asstring);
next;
end;
end;
tmpQuery.Connection := FADOCon; tmpQuery.Close;
tmpQuery.SQL.Clear;
tmpQuery.SQL.Add('SELECT DISTINCT 用户名 FROM login_user;');
tmpQuery.Open; ComboBox1.Items.Clear;
tmpQuery.First;
while not tmpQuery.Eof do
begin
if length(trim(tmpQuery.Fields[0].AsString)) > 0 then
ComboBox1.Items.Add(tmpQuery.Fields[0].AsString);
tmpQuery.Next;
end;
tmpQuery.Free;
adoquery1.next;
begin
Close;
Sql.Clear();
Sql.Add('select name from tabel1');
Open;
combobox1.items.clear;
First;
while not eof do
begin
combobox1.items.add(FieldbyName('name').asstring);
next;
end;
end;