procedure TForm1.Button1Click(Sender: TObject); var i:integer; begin ADODataSet1.Close; ADODataSet1.CommandText:='select * from user_info'; ADODataSet1.Open; i:=ADODataSet1.RecordCount; while not ADODataSet1.Eof do begin ADODataSet1.Edit; ADODataSet1.FieldByName('user_pwd').AsString:='aaaa'; ADODataSet1.Next; end; end;
//删除也一样 procedure TForm1.Button1Click(Sender: TObject); var i:integer; begin ADODataSet1.Close; ADODataSet1.CommandText:='select * from user_info'; ADODataSet1.Open; i:=ADODataSet1.RecordCount; //你需要的数字 ADODataSet1.delete; end;
应该用ADODataSet1.edit
先把查询条件写出来,然后用recordcount
再用edit就可以了
怎么不能用呢?可以的,只要设置不返回记录集就可以了
关键是update和delete的时候怎么知道修改了多少记录或者删除多少记录
var
i:integer;
begin
ADODataSet1.Close;
ADODataSet1.CommandText:='select * from user_info';
ADODataSet1.Open;
i:=ADODataSet1.RecordCount;
while not ADODataSet1.Eof do
begin
ADODataSet1.Edit;
ADODataSet1.FieldByName('user_pwd').AsString:='aaaa';
ADODataSet1.Next;
end;
end;
procedure TForm1.Button1Click(Sender: TObject);
var
i:integer;
begin
ADODataSet1.Close;
ADODataSet1.CommandText:='select * from user_info';
ADODataSet1.Open;
i:=ADODataSet1.RecordCount; //你需要的数字
ADODataSet1.delete;
end;