too many rows affected by update

[Bryan]

I keep getting this error message when I try to do an update batch. Can anybody make any sense of it?

[Bryan]

sometimes the error will look like this:

[Bryan]

I keep getting this error message whenever I try to run a rs.updatebatch() in VB.NET. Can anybody make heads or tails of this?

[Bryan]

and sometimes the error looks like this:

[Derek Stone]

You're either not providing the correct arguments or providing too many. Why are you using COM anyway?

[Bryan]

because I haven't had time to learn ADO.NET

[Guest Sysdev2]

At a guess I'd say you are using some kind of grid control here. You will get this message when you try and update a row because, VB is saying, "hey there's nothing unique enough for me to single out this row for update". The easy solution is to add a unique key field to your table ( if you havent already got one ) and include it in the query that populates the grid. That way VB has something to unique to work with when trying to update your chosen row.

[Bryan]

I'm not using a grid control in any way. It is just pure Database manipulation.