Output Parameter Help

I am running a stored procedure via code but need help with the sytax for
the output parameter:

When I run this it works in SQL:


USE DataInput

GO

DECLARE @MyIdent int



EXEC a_spAppendNewContributionID

@CompanyId=1000,

@PayPeriod="8/12/2006",

@PlanYear=2006,

@ContributionDate="08/25/2006",

@ContributionID = @MyIdent OUTPUT



SELECT @MyIdent AS IdentityValue

SELECT * FROM MassPost


Here's part of my code in asp. The @contributionID section is where I am
stuck, how do I declare the output parameter?

// Add Parameters to SPROC

OleDbParameter parameterCompanyId = new
OleDbParameter("@CompanyId", OleDbType.Integer, 4);
parameterCompanyId.Value = SystemUtils.GetUserID();
myCommand.Parameters.Add(parameterCompanyId);

OleDbParameter parameterPayPeriod = new
OleDbParameter("@PayPeriod", OleDbType.Date, 8);
parameterPayPeriod.Value = this.PayPeriod2.Text;
myCommand.Parameters.Add(parameterPayPeriod);

OleDbParameter parameterPlanYear = new
OleDbParameter("@PlanYear", OleDbType.Integer, 4);
parameterPlanYear.Value = this.PlanYear2.Text;
myCommand.Parameters.Add(parameterPlanYear);

OleDbParameter parameterContributionDate = new
OleDbParameter("@ContributionDate", OleDbType.Date, 8);
parameterContributionDate.Value =
this.ContributionDate2.Text;
myCommand.Parameters.Add(parameterContributionDate);

//Line that does not work

OleDbParameter parameterContributionID = new
OleDbParameter("@ContributionID", OleDbType.Integer, 4);
parameterContributionID.Direction =
ParameterDirection.Output


.

Relevant Pages

  • Another Parameter Question
    ... @ContributionID = @MyIdent OUTPUT ... how do I declare the output parameter? ... OleDbParameter parameterCompanyId = new ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Another Parameter Question
    ... @ContributionID = @MyIdent OUTPUT ... The @contributionID section is where I am ... how do I declare the output parameter? ... OleDbParameter parameterCompanyId = new ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Another Parameter Question
    ... @ContributionID = @MyIdent OUTPUT ... The @contributionID section is where I am ... how do I declare the output parameter? ... OleDbParameter parameterCompanyId = new ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Are you guys sure about + in this sp
    ... Are you using a output parameter or a return value? ... DECLARE @result INT ... CREATE PROC usp OUTPUT) ...
    (microsoft.public.sqlserver.programming)
  • Re: SP Output Parameter Question
    ... OUTPUT in SQL Server really mean OUT/IN. ... I never declare then as OUT unless I really pass information out from ... > I'm checking some legacy SP code and notice that an OUTPUT parameter is declared prior to other INPUT ... from what I can tell this OUTPUT parameter is only used as an INPUT parameter. ...
    (microsoft.public.sqlserver.programming)