TableAdapter Update fail

views:

answers:

TableAdapter Update fail

Hi everyone,

I have a VB windows Form project that connects to several DataTables in an Access DB. On my form I have several textboxes, comboboxes and datetimepickers that are bound to those sources. With one table in particular when I try to update the tableadapter after editing one of the textboxes the update method fails. No exceptions are thrown, but the update method returns a zero value and the data is not updated. The update will work when just the comboboxes or datetimepickers are edited, but as soon as a textbox is edited also, update will not work.

Other DataTables within the project are set up in the same manner but are not having update issues. I can't figure out what about this one particular table is causing an issue. Can anyone give me any thoughts on where or what to troubleshoot?

Thanks!

try adding another textbox or other control pointed to the same source and see if you can get that one to update. Could be something funky with the control's settings that you're missing, and if you start over, it would be fine.

Beth 2010-09-09 13:01:21

Thanks, Beth. I added a new bound textbox but update still would not work. When I added a new DateTimePicker it worked fine. It seems to be something to do with textboxes in particular.

Bill 2010-09-09 15:46:00

does this help? http://geek-goddess-bonnie.blogspot.com/2009/09/fun-with-datasets.html

Beth 2010-09-09 16:11:32

THANK YOU THANK YOU THANK YOU!!!! Rewrote the code in that link (I'm new to programming but believe it's in another language) and it worked like a charm. I'd been stumped for days. So much appreciated, Beth!

Bill 2010-09-09 18:55:10

I think you're not the first one to have that problem.

Beth 2010-09-09 19:22:02

ansaurus

tags:

views:

answers:

TableAdapter Update fail

related questions