adoquery1.close; adoquery1.sql.clear; adoquery1.add('insert into dbinfo('','') values (:a,:b)'); for i:=0 to dbgrid1.columns.count -1 do begin Parameters[1].Value := dbgrid1.columns[i].fieldname; parameters[2].value := dbgridq.columns[i].titlecaption; //依次进行就可以了 adoquery1.execsql; end;
动态创建各个字段,并按照顺序编号,然后从数据库加载各属性
adoquery1.sql.clear;
adoquery1.add('insert into dbinfo('','') values (:a,:b)');
for i:=0 to dbgrid1.columns.count -1 do
begin
Parameters[1].Value := dbgrid1.columns[i].fieldname;
parameters[2].value := dbgridq.columns[i].titlecaption;
//依次进行就可以了
adoquery1.execsql;
end;