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();
 
Back
Top