Oracle Stored Procedure Update with DataSet Refresh

  • Thread starter Thread starter galacta
  • Start date Start date
G

galacta

Hi there
I try to update a dataset through an oracle stored procedure.
This works fine but as the stored procedure changes some fields on the
row, the dataset shows afterwards some wrong column values.

How is it possible to refresh the dataset after an update stored
procedure?

Could someone post a sample or ideas, would appreciate that very much.

Thanks for Help
Markus
 
Markus,

You may either choose to dump the entire dataset and read the contents all
over again - afresh.

The second approach is to put a schema in your dataset, and merge with
another dataset read afresh from the dataset (for inserted and updated
rows), and explicitly try and find the deleted rows and remove them from
your dataset. .NET 2.0 also includes an IndexOf method on DataRowCollection
to facilitate this job. Alternatively you could handle deleted rows in
concurrency checks during a save/update operation.

- Sahil Malik [MVP]
Upcoming ADO.NET 2.0 book - http://tinyurl.com/9bync
 
Back
Top