procedure TFrmIME.BitBtn1Click(Sender: TObject); //导入到TXT
var
F: TextFile;
S: string;
begin
if OpenDialog1.Execute then
begin
try
AssignFile(F, OpenDialog1.FileName);
Rewrite(F);
Query1.open;
while not Query1.Eof do
begin
S := Query1.fieldbyname('编号').asstring + '|' + Query1.fieldbyname('姓名').asstring + '|' + Query1.fieldbyname('出生年月').asstring + '|' + Query1.fieldbyname('奖金').asstring; Writeln(F, S);
Query1.Next;
end;
finally
CloseFile(F);
end;
end;
end;procedure TForm1.Button2Click(Sender: TObject);//导入到数据库
var
F: TextFile;
S, Str: string;
begin
if OpenDialog1.Execute then
begin
try
AssignFile(F, OpenDialog1.FileName);
ReSet(F);
Query1.open; while not Eof(F) do
begin
Query1.Insert;
Readln(F, S);
Str := copy(S, 1, pos('|', S) - 1);
Query1.fieldbyname('编号').asstring := Str;
Delete(S, 1, Pos('|', S));
Str := Copy(S, 1, Pos('|', S) - 1);
Query1.fieldbyname('姓名').asstring := Str;
Delete(S, 1, pos('|', S));
Str := Copy(S, 1, Pos('|', S) - 1);
Query1.fieldbyname('出生年月').asstring := Str;
Delete(S, 1, Pos('|', S));
Query1.fieldbyname('奖金').asstring := Str;
Query1.Post;
end;
finally
CloseFile(F);
end;
end;
end;
//这是基本思路,略加修改即可!
var
F: TextFile;
S: string;
begin
if OpenDialog1.Execute then
begin
try
AssignFile(F, OpenDialog1.FileName);
Rewrite(F);
Query1.open;
while not Query1.Eof do
begin
S := Query1.fieldbyname('编号').asstring + '|' + Query1.fieldbyname('姓名').asstring + '|' + Query1.fieldbyname('出生年月').asstring + '|' + Query1.fieldbyname('奖金').asstring; Writeln(F, S);
Query1.Next;
end;
finally
CloseFile(F);
end;
end;
end;procedure TForm1.Button2Click(Sender: TObject);//导入到数据库
var
F: TextFile;
S, Str: string;
begin
if OpenDialog1.Execute then
begin
try
AssignFile(F, OpenDialog1.FileName);
ReSet(F);
Query1.open; while not Eof(F) do
begin
Query1.Insert;
Readln(F, S);
Str := copy(S, 1, pos('|', S) - 1);
Query1.fieldbyname('编号').asstring := Str;
Delete(S, 1, Pos('|', S));
Str := Copy(S, 1, Pos('|', S) - 1);
Query1.fieldbyname('姓名').asstring := Str;
Delete(S, 1, pos('|', S));
Str := Copy(S, 1, Pos('|', S) - 1);
Query1.fieldbyname('出生年月').asstring := Str;
Delete(S, 1, Pos('|', S));
Query1.fieldbyname('奖金').asstring := Str;
Query1.Post;
end;
finally
CloseFile(F);
end;
end;
end;
//这是基本思路,略加修改即可!
解决方案 »
- 请问Delphi的WebService怎么返回一个记录集?
- 关于combobox.selstart的问题
- 在线等,如何连接orcal?
- 为何在窗体继承中,在被继承窗全中声明的PUBLIC 变值并在被继承窗体赋值后,在继承窗体中访问是为空。
- dll調用問題,暫給20分,如果解決我會給分168
- [转贴灌水]美军攻打中国为什么会惨败??
- 简单问题,怎样把string类型转换成pchar类型?
- 对象数组的创建问题
- 小妹要哭
- 菜鸟问题5:delphi中有没有弹出对话框,要你选择是,否,取消,然后得到返回值,实在很抱歉,我是刚学delphi的新手,很多都不懂
- 怎样在Dbgrid中,动态地加入固定字段呢??也就是列
- 如何增加可修改的数据集字段?
var
F: TextFile;
S: string;
begin
if OpenDialog1.Execute then
begin
try
AssignFile(F, OpenDialog1.FileName);
Rewrite(F);
Query1.open;
while not Query1.Eof do
begin
S := Query1.fieldbyname('编号').asstring + '|' + Query1.fieldbyname('姓名').asstring + '|' + Query1.fieldbyname('出生年月').asstring + '|' + Query1.fieldbyname('奖金').asstring; Writeln(F, S);
Query1.Next;
end;
finally
CloseFile(F);
end;
end;
end;procedure TForm1.Button2Click(Sender: TObject);
var
F: TextFile;
S, Str: string;
begin
if OpenDialog1.Execute then
begin
try
AssignFile(F, OpenDialog1.FileName);
ReSet(F);
Query1.open; while not Eof(F) do
begin
Query1.Insert;
Readln(F, S);
Str := copy(S, 1, pos('|', S) - 1);
Query1.fieldbyname('编号').asstring := Str;
Delete(S, 1, Pos('|', S));
Str := Copy(S, 1, Pos('|', S) - 1);
Query1.fieldbyname('姓名').asstring := Str;
Delete(S, 1, pos('|', S));
Str := Copy(S, 1, Pos('|', S) - 1);
Query1.fieldbyname('出生年月').asstring := Str;
Delete(S, 1, Pos('|', S));
Query1.fieldbyname('奖金').asstring := S;//上面此处有错!
Query1.Post;
end;
finally
CloseFile(F);
end;
end;
end;
//这是基本思路,略加修改即可!