You may have a reserved word as one of your field names in the database.
This will cause the update to fail. You don't show the Insert/delete/update
statements for the DataAdapter so it's hard to tell if this is actually the
problem. If you are using a CommandBuilder set the QuotePrefix and
QuoteSuffix properties appropriately. A field name like password will cause
this error.
Try putting a try/catch statement around your Update call and print the
message and stack trace from the trapped error to get more detail.
Ron Allen
"Newbie!" <s_************@yahoo.co.uk> wrote in message
news:ev********************@karoo.co.uk...
Hey Gorup,
I keep getting this error:
An unhandled exception of type 'System.InvalidOperationException' occurred
in system.data.dll
When trying to run the following code from a Button:
Private Sub btnPasswordListUpdate_Click(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles btnPasswordListUpdate.Click
odaPasswordLists.Update(dsPasswordLists)
End Sub
Anyone have any General Ideas?
Ta
Si