ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle.DataAccess.Client.OracleDataAdapter.Update not working

836901Feb 4 2011 — edited Feb 5 2011

Hi

I am using the Oracle.DataAccess.Client.OracleDataAdapter from Oracle.DataAccess runtime version v4.0.30319. I set the SelectCommand and retrieve data from Oracle without any problems using the adapter to fill a datatable. I then use the DataTable.Clear method to remove all rows and fill it again from a different source using a different adapter. I use the Oracle.DataAccess.Client.OracleCommandBuilder to create the Insert and Update commands and finally I call the update command of the using the original adapter in order to update the Oracle database but nothing is updated.

I examine the table row count at each stage and also display the table using a DataGridView on a form and all appears to be fine. No exception is thrown so I am stumped.

I would be grateful for any suggestions as to what I am doing wrong.

My environment is VS2010 Express

Edited by: user1947494 on 04-Feb-2011 05:46

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 5 2011

Added on Feb 4 2011

#11g, #odp-net

7 comments

1,697 views