ADO.NET DataAdapter Select Command

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

Guest

Hi,

Can I reliably set a Select Command in a DataAdapter to utilize a Stored Procedure that will first insert, then update records and finally return a set of related records in a dataset. I have tried it with a simple test and it seems to works fine. Are the results reliable?

Thanks,
Mark
 
Mark said:
Hi,

Can I reliably set a Select Command in a DataAdapter to utilize a Stored
Click to expand...
Procedure that will first insert, then update records and finally return a
set of related records in a dataset. I have tried it with a simple test and
it seems to works fine. Are the results reliable?
Sure, no problem. If you are using Sql Server, remember to "set nocount on"
at the top of your procedure.

David
 
Back
Top