hi, can u help me
my Datagrid which connected to ADODC1 was updating evrytime i click my ADD command button, then i made another command button to CLEAR what data is in the grid, i used this codes to do that but always error like this "KEY COLUMN INFO IS INSUFFIECIENT OR INCORRECT. TOO MANY ROWS WERE AFFECTED BY UPDATE"
While Not Adodc1.Recordset.EOF
i want when i click clear button, all the data in grid will erase and also in the database.
help me please :)