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
 

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

DataAdapter.Fill with Action Queries and A Select Statement 1
ODBC and C# Express edition 1
NewRow, RowState, and Detached with a CommandBuilder 1
DataAdapter Fill Method Query 2
Confused about the DataAdapter 4
slowing/halting stored procedure from ado.net 8
DataAdapter.Update 3
doubt on Connections and Dataadapters 2

Back
Top