ASP.net call SQL Server store procedure problem. 
<p>I am trying to call a stored procedure in an ASP.NET page and get its return value. Here is my code:</p>

<pre><code>//Something
MyConnection.Open();
SqlDataReader reader = MyCommand.ExecuteReader();

if (reader.Read())
{
    if (returnParameter != null)
        result = Convert.ToInt32(reader[returnParameter.ParameterName]);
}
//Something else
</code></pre>

<p>Everything is working fine, except that the <code>reader.Read()</code> is always returning false, so I cannot get the return value. And the stored procedure is executed. This is confirmed from the server side. There's no exception raised.</p>

<p>What is the problem? </p>
