用adoquery或query 房间号no dbgrid.datasource.dataset.close; dbgrid.datasource.dataset.sql.text := 'select * from house where no = ' + quotedsrt(no); dbgrid.datasource.dataset.open;
在LISTVIEW的CLICK事件内写 adoquery.sql.text:='select * from table1 where 房间号='+''''+listview.selected+''''; adoquery.open;我没有测试,楼主自己试试~。
s:string; s;=select 房间号码 房间价格 from 你的表 wehere 房间号码=strtoing(listview.selectd)adoquery.sql.clear; adoquery.sql..add(s); 下面是标准的查询语句,我给往了,你自己查书看看adoquery.open;
根据大家的意思我写了如下代码,可是不知道哪里错误,请大家指正: procedure TGuest_Wel.BitBtn1Click(Sender: TObject); var lt1:TListItem; begin lt1:=LV_ROOM.Selected; with DataModule1.ShareQuery do begin close; SQL.text:= 'select * from R_Code where Rc_Code='+lt1; Open; LV_ROOM.Selected.Delete; end; end;
程序已经可以运行了,可是在DBGRID中根本无法显示所选择的房间号码,大家可以告诉我如何做吗? procedure TGuest_Wel.BitBtn1Click(Sender: TObject); var lt1:TListItem; begin lt1:=LV_ROOM.Selected; with DataModule1.ShareQuery do begin close; SQL.text:= 'select * from R_Code where Rc_Code='+lt1.caption; Open; LV_ROOM.Selected.Delete; end; end;
procedure TGuest_Wel.BitBtn1Click(Sender: TObject); var lt1:TListItem; begin lt1:=LV_ROOM.Selected; with DataModule1.adoCr1 do begin close; commandtext:= 'select * from R_Code where Rc_Code='+lt1.caption; Open; LV_ROOM.Selected.Delete; end; end;
房间号no
dbgrid.datasource.dataset.close;
dbgrid.datasource.dataset.sql.text := 'select * from house where no = ' + quotedsrt(no);
dbgrid.datasource.dataset.open;
adoquery.sql.text:='select * from table1 where 房间号='+''''+listview.selected+'''';
adoquery.open;我没有测试,楼主自己试试~。
s;=select 房间号码 房间价格 from 你的表 wehere 房间号码=strtoing(listview.selectd)adoquery.sql.clear;
adoquery.sql..add(s);
下面是标准的查询语句,我给往了,你自己查书看看adoquery.open;
在ListView的OnClick事件内写
...
AdoQuery1.Filtered := false;
AdoQuery1.Filter := 'RoomId=' + ListView1.Selectd; {假设其为整型}
AdoQuery1.Filtered := true;
...
procedure TGuest_Wel.BitBtn1Click(Sender: TObject);
var
lt1:TListItem;
begin
lt1:=LV_ROOM.Selected;
with DataModule1.ShareQuery do
begin
close;
SQL.text:= 'select * from R_Code where Rc_Code='+lt1;
Open;
LV_ROOM.Selected.Delete;
end;
end;
procedure TGuest_Wel.BitBtn1Click(Sender: TObject);
var
lt1:TListItem;
begin
lt1:=LV_ROOM.Selected;
with DataModule1.ShareQuery do
begin
close;
SQL.text:= 'select * from R_Code where Rc_Code='+lt1.caption;
Open;
LV_ROOM.Selected.Delete;
end;
end;
var
lt1:TListItem;
begin
lt1:=LV_ROOM.Selected;
with DataModule1.adoCr1 do
begin
close;
commandtext:= 'select * from R_Code where Rc_Code='+lt1.caption;
Open;
LV_ROOM.Selected.Delete;
end;
end;