用sql语句: adodataset1.commandtext:='insert into tablename values(‘..','..')‘; 三层结构直接用query就可以了。
较简单常用方法: ... arrSQl[i]:='Insert Into....' ... TADOConnection.BeginTrans; for i:=0 to high(arrSQL) do TADOConnection.Execute arrSQL[i]; TADOConnection.CommitTrans;
adodataset1.commandtext:='insert into tablename values(‘..','..')‘;
三层结构直接用query就可以了。
...
arrSQl[i]:='Insert Into....'
...
TADOConnection.BeginTrans;
for i:=0 to high(arrSQL) do
TADOConnection.Execute arrSQL[i];
TADOConnection.CommitTrans;