delphi – 调整列宽DBGrid

所需的columnwidth取决于Grids画布的设置和每个字段的displaytext的mamimum长度.

procedure FitGrid(Grid: TDBGrid);
const
  C_Add=3;
var
  ds: TDataSet;
  bm: TBookmark;
  i: Integer;
  w: Integer;
  a: Array of Integer;
begin
  ds := Grid.Datasource.DataSet;
  if Assigned(ds) then
  begin
    ds.DisableControls;
    bm := ds.GetBookmark;
    try
      ds.First;
      SetLength(a,Grid.columns.Count);
      while not ds.Eof do
      begin
        for I := 0 to Grid.columns.Count - 1 do
        begin
          if Assigned(Grid.columns[i].Field) then
          begin
            w :=  Grid.Canvas.TextWidth(ds.FieldByName(Grid.columns[i].Field.FieldName).DisplayText);
            if a[i] < w  then
               a[i] := w ;
          end;
        end;
        ds.Next;
      end;
      for I := 0 to Grid.columns.Count - 1 do
        Grid.columns[i].Width := a[i] + C_Add;
        ds.GotoBookmark(bm);
    finally
      ds.FreeBookmark(bm);
      ds.EnableControls;
    end;
  end;
end;

procedure TForm1.button1Click(Sender: TObject);
begin
  FitGrid(DBgrid1)
end;