procedure TForm1.ComboBox1Change(Sender: TObject); var i:integer; temp:integer; begin temp:=0; ADoDataSet1.Close; AdoDataSet1.CommandText:='select * from 表1 where 需要查询的列名='+quotedStr(ComboBox1.Text); ADoDataSet1.Open; For i:=0 to ADoDataSet1.RecordCount-1 do begin temp:=temp+ADoDataSet1['需要合计的列名']; ADoDataSet1.Next; end; Edit1.Text:=IntToStr(temp); end;
var
i:integer;
temp:integer;
begin
temp:=0;
ADoDataSet1.Close;
AdoDataSet1.CommandText:='select * from 表1 where 需要查询的列名='+quotedStr(ComboBox1.Text);
ADoDataSet1.Open;
For i:=0 to ADoDataSet1.RecordCount-1 do
begin
temp:=temp+ADoDataSet1['需要合计的列名'];
ADoDataSet1.Next;
end;
Edit1.Text:=IntToStr(temp);
end;