1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42
|
procedure TForm1.Button2Click(Sender: TObject);
var StringList:TStrings;
var i:integer;
begin
MyQuery.SQL.Clear;
MyQuery.SQL.Add('SELECT personnel.ID_PERSONNEL, personnel.NOM_PERSONNEL FROM personnel');
MyQuery.Open;
Myquery.First;
StringList :=TStringList.Create;
try
begin
if enregCount(MyQuery)>0 then
begin
for i := 0 to enregCount(MyQuery)-1 do
with StringList do
begin
Add(MyQuery.Fields.Fields[0].AsString +' -- '+ MyQuery.Fields.Fields[1].AsString ) ;
Myquery.Next;
end
end
else
begin
with StringList do
begin
Add('Innexistant') ;
end
end;
end;
with ComboBox1 do
begin
Width :=150;
Items.Assign(StringList);
ItemIndex :=0;
end;
finally
StringList.free;
end;
end; |