0 Replies Latest reply: Nov 28, 2012 7:22 AM by 587815 RSS

    How to Update the DataSet populating from Stored Procedure with SYS_REFCURS

      I created a dataset with the wizard of VS2010 and link each DataTableAdapter stored procedures to insert, update, delete and select (which returns a SYS_REFCURSOR). When you run the program recovery and visualize data in a form, but if I want to update data, there is no change. Use the following code to update, insert and delete:

      BindinSourceEmployee.EndEdit ()
      EmployeeTableAdapter.Update (DataSetHR.Employees)