DbGrid1.DataSource := DataSource1;
DataSource1.dataset := ADOQuery1
with ADOQuery1 do
begin
close;
sql.clear;
sql.text := 'select * from 表';
open;
end;
create procedure GetHRInfo @Lyear varchar(20),@lmonth varchar(20),@bm varchar(20),
@xm varchar(20) as
begin
select a.salary from 工资表 a,员工表 b where b.工号=a.工号 and a.姓名=@xm
and b.年份=@Lyear and b.月份= @Lmonth and a.部门=@bm
end
还有客户端是不是用DbGrid1 DataSource1 AdoStoredProc1. 把查询结果显示到DbGrid1上.要不要用Query1呢?搞不懂了我好闷愈!
要不要用Query1呢?
----》》
不必!
设置参数就可一了
create procedure GetHRInfo
@Salary varchar(20)
as
begin
select a.salary from HR b,GZ a where b.id=a.id and a.salary=@Salary
end
Go