The update command for the oledbdataadapter is

update clients set surname=? where id=?;
select client,surname,forenames,id
from clients
where id=?

I have put the code

oledbdataadapter1.updatecommand.parameters(0).value="test surname" e.t.c

before the line

ans=oledbdataadapter.update(Dsclients1)

but ans always returns false.

when i connect to an sql server database, the update command generated has parameters of the format @parameter name, and I don't need to programatically set the parameter values.

Any ideas?