title: Get output parameter value in ADO.NET
body: <p>My stored procedure has an output parameter:</p>
  
  <pre><code>@ID INT OUT
  </code></pre>
  
  <p>How can I retrieve this using ado.net?</p>
  
  <pre><code>using (SqlConnection conn = new SqlConnection(...))
  {
      SqlCommand cmd = new SqlCommand("sproc", conn);
      cmd.CommandType = CommandType.StoredProcedure;
  
      // add parameters
  
      conn.Open();
  
      // *** read output parameter here, how?
      conn.Close();
  }
  </code></pre>