字段含义:
overday1(加班天数),overhours(加班小时),date(加班日期),overday(表名)
begin
ADOQuery1.Close;
ADOQuery1.Open;
ADOQuery1.SQL.Clear;
sql:='SELECT SUM(overday1) AS overday1,SUM(overhours) AS overhours FROM overday WHERE date >=# '+Datetostr (DateTimePicker1.Date)+ '# AND date <=#'+Datetostr(DateTimePicker2.Date)+'#' ;
ADOQuery1.SQL.Add(sql);
ADOQuery1.Open;
EDit1.Text:= ADOQuery1.FieldByName('overday1').AsString;
EDit2.Text:= ADOQuery1.FieldByName('overhours').AsString;
ADOQuery1.Close;
end;我是想让查询结果显示的EDit1.Text和EDit.Text中。不要显示在DBGrid中,但上面的代码执行之后既显示在EDit1.Text和EDit.Text,又显示在DBGrid中,上面的代码哪里有问题呢?请高手。谢谢
overday1(加班天数),overhours(加班小时),date(加班日期),overday(表名)
begin
ADOQuery1.Close;
ADOQuery1.Open;
ADOQuery1.SQL.Clear;
sql:='SELECT SUM(overday1) AS overday1,SUM(overhours) AS overhours FROM overday WHERE date >=# '+Datetostr (DateTimePicker1.Date)+ '# AND date <=#'+Datetostr(DateTimePicker2.Date)+'#' ;
ADOQuery1.SQL.Add(sql);
ADOQuery1.Open;
EDit1.Text:= ADOQuery1.FieldByName('overday1').AsString;
EDit2.Text:= ADOQuery1.FieldByName('overhours').AsString;
ADOQuery1.Close;
end;我是想让查询结果显示的EDit1.Text和EDit.Text中。不要显示在DBGrid中,但上面的代码执行之后既显示在EDit1.Text和EDit.Text,又显示在DBGrid中,上面的代码哪里有问题呢?请高手。谢谢
打开你的FORM,将DBGrid1的DataSource设为空就可以了