http://p2p.wrox.com/archive/ado_dotnet/2002-07/29.asp"
Herre is a couple of ideas to check out:
1. You need to have a unique key which is a primary key on the table you
want to update. If not, then after the first row, updates fail. (MSSQL
can't determine which row to update) -- seems likely.
2. It is possible that your update statement may need parameters which were
not defined. There is a problem specific to stored procedures which are
dragged over to a form and subsequently used: You need to modify the
parameter definition statements so that the name of the field in memory is
defined ratheer than just "" that is created automatically. This does not
occur when you drag a table over to the form and the sql statements are
created -- those parameters have this field properly defined. Find this
code in the Windows Designer Generated Code region -- seems likely
3. It is possible that you failed to define all the parameters the update
needed. Check in the Windows Designer Generated Code region for the
parameters generated automatically -- did you define them all?
"