Your instructor has no suggestions???? I think I'd look to take a class with another instructor!!
I'm betting that you're doing a DataSet.AcceptChanges() prior to the DataAdapter.Update(), whereas it should be the other way around. But if that's not it, post your code.
~~Bonnie
>To all,
>
>I'm taking an "advanced" VB.NET class and we're working with database updates. I've got the connection/dataAdaptor/dataSet things configured so that everything works UNTIL the dataAdaptor.Update() method is run. Nothing happens. No updates, no errors, no messages. NOTHING!
>
>The dataSet looks fine. The data in the dataSet is Inserting/Updating/Deleting OK. But nothing is going to the data source. Other than the obvious (no changes persisting on the data source) the only indication that something's wrong is a test memvar that I've added. I trap the value returned from the Update() method and that value is zero.
>
>My instructor has no suggestions. If this were Basket Weaving 101 or some such, I'd just blow it off, but I'm a professional database applications developer. I need to know what's wrong here.
>
>TIA,
>Thom C.