各位大大好,下面是我的code,能把dbgrid中的资料转为txt,但是转出来后的栏位名却是sql中的英文名,我想改成dbgrid中的中文名,该怎么做?

procedure TForm1.Button1Click(Sender: TObject);
begin
DbgridToTxt(dbgrid1);
end;

procedure Tform1.DbgridToTxt(source:Tobject);
var
filename:Textfile;
Dataset:Tdataset;
titlestr,valuestr,tempstr:string;
counter:integer;
begin
if (source is Tdbgrid)then
Dataset:=Tdbgrid(source).DataSource.DataSet
else
Dataset:=TDataset(source);
if ((Dataset.IsEmpty)or(not Dataset.Active))then
exit else
begin
Dataset.DisableControls;
Dataset.First;
if savedialog1.Execute then
begin
assignfile(filename,savedialog1.FileName);
rewrite(filename);
for counter:=0 to Dataset.FieldCount-1 do
titlestr:=titlestr char(9) Dataset.Fields[counter].DisplayLabel;
titlestr:=trim(titlestr);
writeln(filename,titlestr);
while not Dataset.Eof do
begin
valuestr:='';
for counter:=0 to Dataset.FieldCount-1 do
begin
tempstr:=Dataset.Fields[counter].Text;
valuestr:=valuestr char(9) tempstr;
end;
valuestr:=trim(valuestr);
writeln(filename,valuestr);
Dataset.Next;
end;
closefile(filename);
end;
Dataset.EnableControls;
end;
end;

要嘛就是寫入TEXT時
一個一個欄位給名稱

for counter:=0 to Dataset.FieldCount-1 do
titlestr:=titlestr char(9) Dataset.Fields[counter].DisplayLabel;
改成:
for counter:=0 to Dataset.FieldCount-1 do
begin
if counter = 0 then....
else if counter = 1 then...
end;

這樣很累...我知道= =


另一個解法是~
當您在Select 時 就先把欄位給改成中文的即可
Ex: Select productname as 產品名稱 From product