Returning Identity Field

Hi all i'm trying to get the identity field after inserting into db, what am i doing wrong? thanks a lot

my sproc:

CREATE PROCEDURE ng_AddCotacao
(
...
@Codigo_cotacao   int OUTPUT
)
AS
BEGIN
SET NOCOUNT ON
INSERT INTO
Negocios_cotacoes
(
...
)
VALUES
(
...
)
SELECT @Codigo_cotacao=SCOPE_IDENTITY()
SET NOCOUNT OFF
END
GO


 

class file

public class Cotacoes

{

public int codigoCotacao;

}

public class CotacaoAtualiza
 {
  public Cotacoes cotacoes = new Cotacoes();

  public CotacaoAtualiza()
  {
  }

  public void AdicionarCotacao(
   ...
   )
  {
   SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["stringConexao"]);
   SqlCommand myCommand = new SqlCommand("ng_AddCotacao", myConnection);

   myCommand.CommandType = CommandType.StoredProcedure;

   ...

   SqlParameter paramCodigo_cotacao = new SqlParameter("@Codigo_cotacao", SqlDbType.Int, 4);
   paramCodigo_cotacao.Direction = ParameterDirection.Output;
   myCommand.Parameters.Add(paramCodigo_cotacao);

   ...

   myConnection.Open();
   SqlDataReader result = myCommand.ExecuteReader();

   while(result.Read())
   {
    this.cotacoes.codigoCotacao = (int) result["@Codigo_cotacao"];
   }

   myConnection.Close();
  }

 

calling into code-behind file:

CotacaoAtualiza ca = new CotacaoAtualiza();

Cotacoes cotacoes = ca.cotacoes;

Response.Redirect("Cotacao_confirma.aspx?cotacao=" + cotacoes.codigoCotacao);