一个文本文件是这样的
王小栓
张大中
要将他们插入到ACCESS表中,但是用我下面的程序就只能插入王小栓,而不能插入张大中,请问为什么?unit Unit1;interfaceuses
Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
Dialogs,Db, ADODB, StdCtrls;type
TForm1 = class(TForm)
ADOConnection1: TADOConnection;
Button1: TButton;
procedure FormCreate(Sender: TObject);
procedure Button1Click(Sender: TObject);
private
{ Private declarations }
public
{ Public declarations }
end;var
Form1: TForm1;
//===================access
SecConstr:wideString;
SecCnn:TADOConnection;
SecDataSet:TADODataSet;
implementation{$R *.dfm}procedure TForm1.FormCreate(Sender: TObject);
begin
SecConStr:='Provider=Microsoft.Jet.OLEDB.4.0;Password="";Data Source=' + ExtractFilePath(Application.ExeName) + '\TEST.mdb;Persist Security Info=True';
SecCnn:=TADOConnection.Create(nil);
SecCnn.LoginPrompt:=false;
SecDataSet:=TADODataSet.Create(nil);
//打开access连接
Seccnn.ConnectionString:=SecConstr;
SecCnn.Open;
end;procedure TForm1.Button1Click(Sender: TObject);
var
F: TextFile;
ID: String[8];
Name: String[8];
begin //有问题的地方
SecDataSet.Connection:=SecCnn;
SecDataSet.CommandText:='select * from hou';
SecDataSet.Open;
AssignFile(F,'table.txt');
Reset(F);
while not Eof(F) do
begin
Readln(F,NAME);
SecDataSet.Append;
SecDataset.Fields[1].AsString:=Name;
end;
CloseFile(F);
end;
end.
王小栓
张大中
要将他们插入到ACCESS表中,但是用我下面的程序就只能插入王小栓,而不能插入张大中,请问为什么?unit Unit1;interfaceuses
Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
Dialogs,Db, ADODB, StdCtrls;type
TForm1 = class(TForm)
ADOConnection1: TADOConnection;
Button1: TButton;
procedure FormCreate(Sender: TObject);
procedure Button1Click(Sender: TObject);
private
{ Private declarations }
public
{ Public declarations }
end;var
Form1: TForm1;
//===================access
SecConstr:wideString;
SecCnn:TADOConnection;
SecDataSet:TADODataSet;
implementation{$R *.dfm}procedure TForm1.FormCreate(Sender: TObject);
begin
SecConStr:='Provider=Microsoft.Jet.OLEDB.4.0;Password="";Data Source=' + ExtractFilePath(Application.ExeName) + '\TEST.mdb;Persist Security Info=True';
SecCnn:=TADOConnection.Create(nil);
SecCnn.LoginPrompt:=false;
SecDataSet:=TADODataSet.Create(nil);
//打开access连接
Seccnn.ConnectionString:=SecConstr;
SecCnn.Open;
end;procedure TForm1.Button1Click(Sender: TObject);
var
F: TextFile;
ID: String[8];
Name: String[8];
begin //有问题的地方
SecDataSet.Connection:=SecCnn;
SecDataSet.CommandText:='select * from hou';
SecDataSet.Open;
AssignFile(F,'table.txt');
Reset(F);
while not Eof(F) do
begin
Readln(F,NAME);
SecDataSet.Append;
SecDataset.Fields[1].AsString:=Name;
end;
CloseFile(F);
end;
end.
解决方案 »
- 请教大家回调函数的问题。
- 将memo 中的文字保存到txt文档中
- 请问如何自动隐藏任务栏..且当鼠标移到底部时状态栏出现 ,移走后隐藏....
- 菜鸟提问:程序打包发布问题(sql server 2000+bde+多层) 使用installshield express
- 打印时如何只打印表单中的DbGrid和Panel,而其它控件不打印呢?难啊。
- 有没有人用过CadoDraw??????????
- 我的ID字段在数据库中是自动增加的,为什么当我在TTABLE中更新数据时,会出错,有什么解决办法?
- 请问上哪找delphi的界面?
- 在SQL Server中如何改变一个table中一列的字段属性?
- 求一段文件下载及显示下载速度的代码。
- dxDBGrid能否做成每行的颜色交替显示?
- 请教一个简单问题
SecDataSet.Connection:=SecCnn;
SecDataSet.CommandText:='select * from hou';
SecDataSet.Open;
AssignFile(F,'table.txt');
Reset(F);
while not Eof(F) do
begin
Readln(F,NAME);
SecDataSet.Append;
SecDataset.Fields[1].AsString:=Name;
//////这要 post 啊
end;
CloseFile(F);
end;
end.