none
UpdateRowSource.FirstReturnedRecord not working on .Net 2.0 RRS feed

  • Question

  • I have a project that has been upgraded from .Net 1.1 to 2.0 and I cannot get
    the UpdateRowSource.FirstReturnedRecord of the InsertCommand to work
    correctly using the System.Data.OracleClient. It works correctly on 1.1 and
    the DataSet is updated correctly after a DataAdapter.Update, but although the
    insert happens to the database on 2.0, the DataSet is not updated.

    My InsertCommand is a stored procedure that gets the next id (primary key)
    for the tables instance, inserts the new record with the id, and then gets
    the newly inserted row as an output, using oracle REF CURSOR.

    Has anybody run into this problem and found a work-around?

    Regards,
    Tommaso

    Monday, December 14, 2009 10:00 AM

All replies

  • Hello Tommaso,

    Which version of Visual Studio,.NET Framework and Oracle data provider are you using now?   Also, please use the latest data provider to connect the Oracle database.


    Best Regards,
    Lingzhi Sun


    Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.
    Wednesday, December 16, 2009 9:13 AM
    Moderator