whats new ¦  programming tips ¦  indy articles ¦  intraweb articles ¦  informations ¦  links ¦  interviews
 misc ¦  tutorials ¦  Add&Win Game

Tips (1548)

Database (90)
Files (137)
Forms (107)
Graphic (116)
IDE (21)
Indy (5)
Internet / LAN (131)
IntraWeb (0)
Math (76)
Misc (127)
Multimedia (45)
Objects/
ActiveX (51)

OpenTools API (3)
Printing (35)
Strings (83)
System (268)
VCL (243)

Top15

Tips sort by
component


Search Tip

Add new Tip

Add&Win Game

Advertising

40 Visitors Online


 
...autosize a dbgrid-column to fit its contents?
Autor: Old man from up north
[ Print tip ]  

Tip Rating (32):  
     


{ Thanks to Thomas Stutz' tip on this site!}
{ A dbgrid is awkward since it has no cells,}
{ you have to step through the table using next;}
{ This procedure is however slow }

procedure SetGridColumnWidths(Grid: Tdbgrid);
const
  
DEFBORDER = 10;
var
  
temp, n: Integer;
  lmax: array [0..30] of Integer;
begin
  with 
Grid do
  begin
    
Canvas.Font := Font;
    for n := 0 to Columns.Count - 1 do
      
//if columns[n].visible then
      
lmax[n] := Canvas.TextWidth(Fields[n].FieldName) + DEFBORDER;
    grid.DataSource.DataSet.First;
    while not grid.DataSource.DataSet.EOF do 
    begin
      for 
n := 0 to Columns.Count - 1 do 
      begin
        
//if columns[n].visible then begin
        
temp := Canvas.TextWidth(trim(Columns[n].Field.DisplayText)) + DEFBORDER;
        if temp > lmax[n] then lmax[n] := temp;
        //end; { if }
      
end{for}
      
grid.DataSource.DataSet.Next;
    end{ while }
    
grid.DataSource.DataSet.First;
    for n := 0 to Columns.Count - 1 do
      if 
lmax[n] > 0 then
        
Columns[n].Width := lmax[n];
  end{ With }
end{SetGridColumnWidths  }

procedure TForm1.Button1Click(Sender: TObject);
begin
  
SetGridColumnWidths(dbgrid3);
end;


 

Rate this tip:

poor
very good


Copyright © by SwissDelphiCenter.ch
All trademarks are the sole property of their respective owners