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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calling Oracle 10g stored procedures from .Net 2.0 4
EnterpriseLibrary. Return Recordset from oracle stored procedure 2
Oracle Stored Procedure - with more than a row? 3
Oracle stored procedure with table as input parameter? 1
UpdateRowSource.FirstReturnedRecord not working on .Net 2.0 0
Stored procedure name in config file? 1
Strongly Typed DataSets and "Refresh the data table" Option 6
Fill typed dataset with one stored procedure call 3

Back
Top