//使dbGrid的内容自动适应他的宽度 procedure MakeDBGridColumnsAutoFixItsWidth(objDBGrid:TDBGrid); var cc:integer; i,tmpLength:integer; objDataSet:TDataSet; aDgCLength:array of integer; begin cc:=objDbGrid.Columns.Count-1; objDataSet:=objDbGrid.DataSource.DataSet; setlength(aDgCLength,cc+1); file://取标题字段的长度 for i:=0 to cc do begin aDgCLength[i]:= length(objDbGrid.Columns[i].Title.Caption); end; objDataSet.First; while not objDataSet.Eof do begin file://取列中每个字段的长度 for i:=0 to cc do begin tmpLength:=length(objDataSet.Fields.Fields[i].AsString); if tmpLength>aDgCLength[i] then aDgCLength[i]:=tmpLength; end; objDataSet.Next; end; for i:=0 to cc do begin objDbGrid.Columns[i].Width:=aDgCLength[i]*7; end; end;
你可以将DBGrid的dgColumnResize属性改成true,然后自己调节
dbgrid1.columns[1].width:=100;
dbgrid1.columns[2].width:=100;
dbgrid1.columns[3].width:=100;
……
procedure MakeDBGridColumnsAutoFixItsWidth(objDBGrid:TDBGrid);
var
cc:integer;
i,tmpLength:integer;
objDataSet:TDataSet;
aDgCLength:array of integer;
begin
cc:=objDbGrid.Columns.Count-1;
objDataSet:=objDbGrid.DataSource.DataSet;
setlength(aDgCLength,cc+1);
file://取标题字段的长度
for i:=0 to cc do
begin
aDgCLength[i]:= length(objDbGrid.Columns[i].Title.Caption);
end; objDataSet.First;
while not objDataSet.Eof do
begin
file://取列中每个字段的长度
for i:=0 to cc do
begin
tmpLength:=length(objDataSet.Fields.Fields[i].AsString);
if tmpLength>aDgCLength[i]
then aDgCLength[i]:=tmpLength;
end;
objDataSet.Next;
end;
for i:=0 to cc do
begin
objDbGrid.Columns[i].Width:=aDgCLength[i]*7;
end;
end;