自己之前么用过Delphi,望各位大侠指点……
用下面的SQL,如果用DBGrid,可以显示汇总后的结果 sum(qty)列,
如果用StringGrid,该怎么带出 sum(qty)的结果呢? SQL1:='select ordnum,linnum,prod,sum(qty) FROM [dbecdfn].[dbo].[pur550db] where stat=2 ';
sql2:=' and uploaddte>='+trim(formatdatetime('yyyymmdd',datetimepicker1.Date))+' and uploaddte <'+trim(formatdatetime('yyyymmdd',datetimepicker2.Date)) ;
sql3:='group by ordnum,linnum,prod order by ordnum,linnum,prod';
qry1.Active:=False;
qry1.SQL.Add(SQL1);
qry1.SQL.Add(SQL2);
qry1.SQL.Add(sql3);
qry1.Prepared;
qry1.Active:=True; StringGrid1.RowCount:=2;
while not qry1.Eof do begin
StringGrid1.RowCount:=StringGrid1.RowCount+1;
StringGrid1.Rows[ StringGrid1.RowCount-1].Clear; StringGrid1.Cells[1,StringGrid1.RowCount-1]:=Trim(qry1.fieldbyname('ordnum').AsString);
StringGrid1.Cells[2,StringGrid1.RowCount-1]:=Trim(qry1.fieldbyname('linnum').AsString);
StringGrid1.Cells[3,StringGrid1.RowCount-1]:=Trim(qry1.fieldbyname('prod').AsString);
qry1.Next;
用下面的SQL,如果用DBGrid,可以显示汇总后的结果 sum(qty)列,
如果用StringGrid,该怎么带出 sum(qty)的结果呢? SQL1:='select ordnum,linnum,prod,sum(qty) FROM [dbecdfn].[dbo].[pur550db] where stat=2 ';
sql2:=' and uploaddte>='+trim(formatdatetime('yyyymmdd',datetimepicker1.Date))+' and uploaddte <'+trim(formatdatetime('yyyymmdd',datetimepicker2.Date)) ;
sql3:='group by ordnum,linnum,prod order by ordnum,linnum,prod';
qry1.Active:=False;
qry1.SQL.Add(SQL1);
qry1.SQL.Add(SQL2);
qry1.SQL.Add(sql3);
qry1.Prepared;
qry1.Active:=True; StringGrid1.RowCount:=2;
while not qry1.Eof do begin
StringGrid1.RowCount:=StringGrid1.RowCount+1;
StringGrid1.Rows[ StringGrid1.RowCount-1].Clear; StringGrid1.Cells[1,StringGrid1.RowCount-1]:=Trim(qry1.fieldbyname('ordnum').AsString);
StringGrid1.Cells[2,StringGrid1.RowCount-1]:=Trim(qry1.fieldbyname('linnum').AsString);
StringGrid1.Cells[3,StringGrid1.RowCount-1]:=Trim(qry1.fieldbyname('prod').AsString);
qry1.Next;
解决方案 »
- 我是菜鸟!请教not supported by automation object 如何解决呢!?
- 请教 搜索网段内MS SQL Server 服务器的API
- 请问如何使用递归,TKS!在线等…
- 有奖捉疵 50分 怎么打*****号部分的代码总不执行啊?
- (高分求教,急)数据库分类统计报表并各自求和?用QREPORT上的控件如何实现。
- 请问哪里有用DELPHI编的VOD视频点播系统的源代码?
- 有没有高手给个d2007做的邮件服务器的源码给我
- 向命令行窗口发送中文的问题,出现乱码!
- 在delphi中如何使用Windows API函数
- DELPHI 开发微信支付
- fastreport 中预览打印后,如果用命令来关闭预览窗口
- dbgrid 中显示的记录如何增加
var i:integer;
begin
......
while not qry1.Eof do begin
StringGrid1.RowCount:=StringGrid1.RowCount+1;
StringGrid1.Rows[ StringGrid1.RowCount-1].Clear;
for i:=0 to 3 do
StringGrid1.Cells[i+1,StringGrid1.RowCount-1]
:=Trim(qry1..Fields.Fields[i].AsString);
qry1.Next;
end;
......