按条件查询时DBGrid1不显示数据,查询全部数据(不按条件时)DBGrid1可以显示查询结果!
大家帮帮忙!
procedure Tcxdy.suiButton1Click(Sender: TObject);
var
sfz:string;
dwm:string;
begin
if suiRadioButton3.Checked =true then begin
with ADODataSet1 do
ADODataSet1.Close;
ADODataSet1.CommandText :='SELECT * from rygl';
ADODataSet1.Open;
end ;
if suiRadioButton2.Checked =true then begin
if suiComboBox1.Text='' then showmessage('请选择要查询的单位名!!')
else begin
with ADODataSet1 do
ADODataSet1.Close;
dwm:= suiComboBox1.Text ;
ADODataSet1.CommandText :='SELECT * from rygl where danwei=:dwm order by 编号';
ADODataSet1.Open;
end ;
end ;
if suiRadioButton1.Checked =true then begin
if suiComboBox1.Text='' then showmessage('请输入要查询的身份证号码!!')
else begin
with ADODataSet1 do
ADODataSet1.Close;
sfz:= suiComboBox1.Text ;
ADODataSet1.CommandText :='SELECT * from rygl where shenfenzheng=:sfz order by 编号';
ADODataSet1.Open;
end;
end;
end;
大家帮帮忙!
procedure Tcxdy.suiButton1Click(Sender: TObject);
var
sfz:string;
dwm:string;
begin
if suiRadioButton3.Checked =true then begin
with ADODataSet1 do
ADODataSet1.Close;
ADODataSet1.CommandText :='SELECT * from rygl';
ADODataSet1.Open;
end ;
if suiRadioButton2.Checked =true then begin
if suiComboBox1.Text='' then showmessage('请选择要查询的单位名!!')
else begin
with ADODataSet1 do
ADODataSet1.Close;
dwm:= suiComboBox1.Text ;
ADODataSet1.CommandText :='SELECT * from rygl where danwei=:dwm order by 编号';
ADODataSet1.Open;
end ;
end ;
if suiRadioButton1.Checked =true then begin
if suiComboBox1.Text='' then showmessage('请输入要查询的身份证号码!!')
else begin
with ADODataSet1 do
ADODataSet1.Close;
sfz:= suiComboBox1.Text ;
ADODataSet1.CommandText :='SELECT * from rygl where shenfenzheng=:sfz order by 编号';
ADODataSet1.Open;
end;
end;
end;
解决方案 »
- BDE中Tquery控件连接oracle数据库的问题
- 请问panel组件可以清空吗?那位大侠进来说说呀!!!
- 谁帮我啊?
- WebServer+soap+分布式开发 应用程序,如何构架??
- 如何得到客户端ip地址?
- 怎样才能将很多个PDF文件合并成一个文件,谢谢了!
- 看不明白的小程序!!!(等待中)
- 用Dede反编遇到的问题
- 关于Idhttp的一个简单用法问题
- 我在做控件时,参考VCL源码,发现有许多CM_XXXX,CN_XXXX的消息,是VCL内部的消息,察看书本,它说在联机帮助中有说明,但我找遍也没有,请问在哪儿?
- 转换函数问题?麻烦大家了.
- 我实在太菜了,ADO,如何连接EXCEL,大虾给个具体的说明吗?
ADODataSet1.CommandText :='SELECT * from rygl where shenfenzheng=' +quotedstr(dwm)+' order by 编号';
上面少了个'='号
ADODataSet1.CommandText :='SELECT * from rygl where danwei=:dwm order by 编号';
ADOQuery1.Parameters[0].Value:=dwm; // 这里要加
...
sfz:= suiComboBox1.Text ;
ADODataSet1.CommandText :='SELECT * from rygl where shenfenzheng=:sfz order by 编号';
ADODataSet1..Parameters[0].Value:=sfz; // 同理