-----------------------------------------------------------------------------------------------------------------------------------------------
本文提示:《数据筛选技巧》是本站编辑们为广大网友精选的实用文章,本文阐述了关于文章的相关理论,相对来说专业性强,但是本文只是针对于某个问题提出的见解与论述,未必能辐射到相关问题的方方面面,所以本文处理问题的方法仅仅为您提供一些参考。更多问题请查阅学习中国网其他栏目哦.
-----------------------------------------------------------------------------------------------------------------------------------------------
1.用filter实现根据数据源筛选数据:
DBGRID.OPEIONTS.dgMultiSelect:=ture;
FilterString:='';
with table1 do
for i:=0 to dbgrid1.SelectedRows.Count-1 do
begin
GotoBookmark(pointer(dbGrid1.SelectedRows.items[i]));
Mkcentlist.Add(Fields[0].asstring);
if FilterString='' then
FilterString:='field1='+''''+Fields[0].asstring+''''
else
FilterString:='field1='+''''+Fields[0].asstring+''''+' or '+FilterString;
end;
wiht query1 do
begin
if FilterString<>'' then
begin
Filter:=FilterString;
Filtered:=true;
end else
begin
Filter:='';
Filtered:=False;
end;
end;
2.根据所选择的条件,后台动态生成sql语句
(出处:www.delphibbs.com)