TableAdapter.Update = No Updates

  • Thread starter Thread starter Jay Pondy
  • Start date Start date
J

Jay Pondy

Need some troubleshooting guidance on this one as I am stumped as to
where or what to look at next.

I have a VS2005 strongly typed dataset with a TableAdapter using
SQL2000 stored procedures for select, insert, update and delete.

The Select command works fine.

When I call the TableAdapters.Update method with added, modified or
deleted rows there is a short pause and then the method returns with
NO errors and a return of 0.

I have checked the rows in the underlying datatable and their row
states are in fact, added, modified and/or deleted before the Update
method call and they are still that way when the update method
returns.

I've looked at the dataset designer code and it looks like it should
work.

I've checked the SP parameter directions, types, mapping etc. etc. and
everything looks fine but something is obviously wrong.

Any advice on where or what to look at to move this toward resolution?
 
I used SQL Server Profiler to see if there were any calls to the
server when the update method was executed - there were none.

I then deleted the Table/TableAdapter from the DataSet and then added
it back in and re-configured it. Voila' - it works - go figure.
 
Back
Top