可以啊: var s:tstringlist; begin s:=tstringlist.create; with adoquery1 do begin close; sql.clear; sql.add('select filed from youtable where condition'); open; while not eof do begin s.add(FieldByName('field').asstring); next; end; end; end;
function form1.GetStringList(AQuery:ADOQuery):TStringList; var s:tstringlist; begin s:=tstringlist.create; with AQuery do begin close; sql.clear; sql.add('select filed from youtable where condition'); open; first; while not eof do begin s.add(FieldByName('field').asstring); next; end; end; result:=s; s.free; end;
procedure TFrmModule.refreshLV(NameStr: string); var NodeId:string; endflag:boolean; IntLen:integer; item:TListItem; begin endflag := false; while not endflag do begin IntLen := pos(',',NameStr); if IntLen <> 0 then begin NodeId := copy(NameStr,1,IntLen - 1); NameStr := copy(NameStr,IntLen + 1 ,length(NameStr)); end else begin NodeId := NameStr ; endflag := true; end;
with cdsQuerySetupQXU do begin Locate('fieldcode',NodeId,[]); item := listview1.Items.Add; item.Caption := fieldbyname('fieldname').AsString; item.SubItems.Add(fieldbyname('fieldcode').AsString); end; end; end;
var
s:tstringlist;
begin
s:=tstringlist.create;
with adoquery1 do
begin
close;
sql.clear;
sql.add('select filed from youtable where condition');
open;
while not eof do
begin
s.add(FieldByName('field').asstring);
next;
end;
end;
end;
var
s:tstringlist;
begin
s:=tstringlist.create;
with AQuery do
begin
close;
sql.clear;
sql.add('select filed from youtable where condition');
open;
first;
while not eof do
begin
s.add(FieldByName('field').asstring);
next;
end;
end;
result:=s;
s.free;
end;
怎么把TSTRINGLIST在风格为REPORT里面的LISTVIEW中显示出来?
var
NodeId:string;
endflag:boolean;
IntLen:integer;
item:TListItem;
begin
endflag := false;
while not endflag do
begin
IntLen := pos(',',NameStr);
if IntLen <> 0 then
begin
NodeId := copy(NameStr,1,IntLen - 1);
NameStr := copy(NameStr,IntLen + 1 ,length(NameStr));
end else
begin
NodeId := NameStr ;
endflag := true;
end;
with cdsQuerySetupQXU do
begin
Locate('fieldcode',NodeId,[]);
item := listview1.Items.Add;
item.Caption := fieldbyname('fieldname').AsString;
item.SubItems.Add(fieldbyname('fieldcode').AsString);
end;
end;
end;