如题,要源码
解决方案 »
- delphi2010默认是将CnPack给屏蔽了的,请问如何才能在2010上使用CnPack
- [Error] report_cur.pas(157): Incompatible types: 'String' and 'TStrings'
- 为什么我建的两个多线程,只能进一个?谢谢!!!在线等待,急!!!!
- 请问:把数组用copy()的方式取出的值不能付给另一个数组嘛?
- Tregistry类中有没有修改现有的注册表某个值的方法呢?
- 怎样获得错误信息
- 如何调用其他 Unit 中的Tstrings型数据?
- 我想实现mdi主窗体打开后,子窗体不出现,为什么这样不行呢,帮个忙,谢谢大家
- 实体类动态赋值问题?(200分)
- 请问高手!!!
- FastReport的初级问题
- fastreport保存为excel的问题,分不够可以再加!!
var F:TextFile;
I,j:integer;
exportsize:integer;
TitleSize:integer;
bookMark:TBook;
begin
assignFile(f,FieldName);
rewrite(f);
for i:=0 to dataset.FieldCount-1 do
begin
write(f,dataset.fields[i].displaylabel,'');
end;
writeln(f);
dataset.DisableControls;
bookMark:=dataset.GetBook;
dataset.First;
for i:=0 to dataset.RecordCount-1 do
begin
for j:=0 to dataset.FieldCount-1 do
begin
write(f,dataset.fields[j].asstring,'');
write(f,char(#9),'');
end;
dataset.Next;
writeln(f);
end;
dataset.GotoBook(bookMark);
dataset.FreeBook(book);
dataset.EnableControls;
writeln(f);
closeFile(f);
end;
这里有很详细的文件读写的说明,还有源码
Book:tBook;//标签
s:widestring;
i,j:integer;
begin
memo:=tstringlist.Create;
Book:=DataSet.GetBook; //标注当前纪录位置
ADODataSet1.First; //移到第一条纪录
while not ADODataSet1.Eof do //如果到最后退出
begin
s:='';
for i:=0 to ADODataSet1.FieldCount-1 do
s:=s+'|'+ADODataSet1.Fields[I].AsString; //当前纪录增加到s用'|'隔开字段
memo.Append(s);//将s追加到memo
ADODataSet1.Next;
end;
ADODataSet1.GotoBook(Book); //返回原来纪录
memo.savetofile('c:\ss.txt'); //保存到文件
end;
三个按钮 ,导出无类型文件,再导入数据库,
procedure TForm1.Button1Click(Sender: TObject);
begin
if savedialog1.Execute then //导出数据
begin
adodataset1.SaveToFile(savedialog1.FileName,pfadtg);
// adodataset1.SaveToFile(savedialog1.FileName,pfxml);
end;
end;procedure TForm1.Button2Click(Sender: TObject);
begin
if opendialog1.Execute then //导入
begin adotable1.LoadFromFile(opendialog1.FileName);
adotable1.First;
end;
end;procedure TForm1.Button3Click(Sender: TObject);
var i,i2:integer;
begin
with adotable1 do
begin for i:=1 to recordcount do
begin
i2:=adotable1['id'];
edit1.Text:=inttostr(i2);
adotable2.Active:=true;
adotable2.Filter:=' id = '''+edit1.text+''' ';
adotable2.Filtered:=true; adotable2.edit;
adotable2['name']:=dbedit1.text;
adotable2['text']:=dbedit2.Text;
adotable2.post;
adotable1.Next;
//adotable2.Active:=false; }
end;
end;
if adotable1.Eof=true
then showmessage('finish!!!!')
end;end.