listview1.clear;
with adoquery1 do
begin
  Sql.text := 'Select * from table1';
  Open ;

  while not eof do
  begin
    with listview1.items.add do
    begin
      caption := fieldbyName('field1').asstring;
      subitems.add(fieldbyName('field2').asstring);
      subitems.add(fieldbyName('field3').asstring);
      subitems.add...
    end;
    Next;
  end;
end;