DataAdapter.Fill with Action Queries and A Select Statement

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I need to run a rather extensive stored procedure which will insert and update a set of records and then return a set of records. I would like the action queries to be run in a transaction and return a set of records that will fill a DataSet.

If I use this stored procedure as a SelectCommand of a DataAdapter, can I expect the action queries as well as the Select statement to be executed reliably. Will my DataSet be accuarately filled?

Thanks,
Mark
 
Yes, I don't see why not .. Though the transactions you mention, are they DB
transactions or ADO.NET transactions?

- SM


Mark said:
Hi,

I need to run a rather extensive stored procedure which will insert and
Click to expand...
update a set of records and then return a set of records. I would like the
action queries to be run in a transaction and return a set of records that
will fill a DataSet.
If I use this stored procedure as a SelectCommand of a DataAdapter, can I
Click to expand...
expect the action queries as well as the Select statement to be executed
reliably. Will my DataSet be accuarately filled?
 
Back
Top