UPDATE is not
Posted on 2004-11-18
Have VB.NET program
Used datset wizard, adapter wizard etc to set the stuff up.
I have code that adds rows to the one table in the dataset.
Then it updates the database, SQL
Except, when one queries the database/table there is nothing added to the table.
code to add rows
and if I step throw it, the rows do in fact get added, column values filled etc.
'actually tried various forms, overloads - no differences
Catch e As 'well one issue - which type of error to catch for
MsgBox(whatevererror is can catch)
What happens as above, is no errors, no fouls.
Except, actually NO DATA gets written to the database.
If I comment out "...acceptchanges"
Then I get DBConcurrencyException
with no additional info.
As each datarow is unique - else I'd get errors adding/changing them during processing
Plus I have double checked that at the Try and they are in fact unique
The DBConcurrencyException tells me, and gee this is helpfull:
(0) rows affected.
Like that is helpful.
BTW: Right now there is nothing in the table on the database
But I use to have data (this table serves as temporary table, so once finished processing it deletes the data)
Point being I know the table works - is structured properly.