Get a value of a select from a stored procedures in C#

Question

I make a select in a stored procedure

SELECT id
FROM table
WHERE isbn = @Isbn

I want to get this value in a webservice.

So i make this :

SqlCommand cmd = new SqlCommand("MyStoredProcedure", connection);
cmd.CommandType = CommandType.StoredProcedure;

object returnObj = cmd.ExecuteScalar();
int returnValue = -1;
if (returnObj != null)
{

     int.TryParse(returnObj.ToString(), out returnValue);
}

But returnValue is always null.

How can I get the value from the SELECT from my stored procedure ?

Does this answer your question? [Calling stored procedure with return value](https://stackoverflow.com/questions/6210027/calling-stored-procedure-with-return-value) — Bryan Dellinger, Apr 30 '21 at 12:23

score 0 · Answer 1 · answered Apr 30 '21 at 12:57

Try this:

private int LoadUsingOpenReader(SqlDataReader dr)
{
   return (int)dr["id"];
}

SqlDataReader dr = null;
SqlCommand cmd = new SqlCommand("MyStoredProcedure", connection);
cmd.CommandType = CommandType.StoredProcedure;

 dr = cmd.ExecuteReader();
 int returnValue = -1;

 if (dr.Read())
 {
     returnValue = LoadUsingOpenReader(dr);
 }

Get a value of a select from a stored procedures in C#

1 Answers1