怎么用delphi代码实现DBGrid双击加入字段,并且设置字段汇总的功能呀?
我的代码如下:
iFieldCount := DM.EditADOQuery.FieldCount;
for i:= 1 to iFieldCount do
begin
DBGridEh1.Columns[i-1].FieldName := DM.EditADOQuery.Fields[i-1].Name;
if i <> 1 then
DBGridEh1.Columns[i-1].Footer.ValueType := fvtSum;
End;
编译没有问题,运行时出错。不知道该怎么写才对。
我的代码如下:
iFieldCount := DM.EditADOQuery.FieldCount;
for i:= 1 to iFieldCount do
begin
DBGridEh1.Columns[i-1].FieldName := DM.EditADOQuery.Fields[i-1].Name;
if i <> 1 then
DBGridEh1.Columns[i-1].Footer.ValueType := fvtSum;
End;
编译没有问题,运行时出错。不知道该怎么写才对。
procedure TForm1.DBGridEh1DblClick(Sender: TObject);
var
i,iFieldCount : Integer;
begin
iFieldCount := ADOQuery1.FieldCount;
for i := 0 to iFieldCount-1 do
begin
DBGridEh1.Columns.Add;
DBGridEh1.Columns[i].FieldName := ADOQuery1.Fields[i].FieldName;
if i >0 then
DBGridEh1.Columns[i].Footer.ValueType := fvtSum;
DBGridEh1.SumList.Active := True;
end;
end;
DBGridEh1.Columns.AddAllColumns(true); //添加Columns
for i:= 1 to DM.AccoutEnterADOSp.FieldCount-1 do
DBGridEh1.Columns[i].Footer.ValueType := fvtSum;
中应该是DM.EditADOQuery.Fields[i-1].FieldName; begin
DBGridEh1.SumList.Active := true;
iFieldCount := qry.FieldCount;
for i:= 1 to iFieldCount do
begin
if i <> 1 then
begin
DBGridEh1.Columns[i-1].Footer.ValueType := fvtSum;
DBGridEh1.Columns[i-1].Footer.WordWrap := true;
end;
End;
end;