DBGridEh2.DataSource.DataSet.First; while not DBGridEh2.DataSource.DataSet.Eof do begin DBSELECT.SQL.Text := SQLCommand1.getSQLPassByFormat('UPDATE_NEW',[...]); DBSELECT.ExecSQL; DBSELECT.Close; DBGridEh2.DataSource.DataSet.Next; end; 我这样循环每一行,更新的数据不知道还有什么更好的办法
DBGridEh2.DataSource.DataSet.First;
while not DBGridEh2.DataSource.DataSet.Eof do
begin
DBSELECT.SQL.Text := SQLCommand1.getSQLPassByFormat('UPDATE_NEW',[...]);
DBSELECT.ExecSQL;
DBSELECT.Close;
DBGridEh2.DataSource.DataSet.Next;
end; 我这样循环每一行,更新的数据不知道还有什么更好的办法
DBGridEh2.DataSource.DataSet.DisableControls;
//......
DBGridEh2.DataSource.DataSet.EnableControls;