Stored procedure for recordset access

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

Guest

I use sqlCommand object in conjunction with sqlDataReader but can't find a
method that can access a recordset that holds one new id from the SP's
select. Thanks.

SqlCommand salesCMD = new SqlCommand("sp_GetEdgilTransactionId ", nwindConn);
salesCMD.CommandType = CommandType.StoredProcedure;// StoredProcedure;
nwindConn.Open();
SqlDataReader myReader = salesCMD.ExecuteReader();
 
You must log in or register to reply here.

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

Output parameter when using storedProcedure 14
Can You Run a Stored Procedure Using SQLDataAdapter? 2
Issue retriving data from mssql 2005 1
How send SP parameters to the function, which creates dataReader 3
xmldatareader? 3
SQL Stored returning uniqueidentifier 4
Problem with return value. 7
stored procedure have no results 6

Back
Top