Please Help! Cannot See Values In Output Params From SQL Server 2000 Using C# / ASP.NET

Hi,





I've got the following C# function to add a customer record to the database. The record gets added without any problems but the OUTPUT PARAMETER (Parameter[10]) is always NULL and I can't see why. I'm also using the Microsoft Data Application Block.





Here's the C# function:





public void SaveCustomer(int customerId,string customerName,string address1,


string address2,


string town,


string county,


string postcode,


string webSiteAddress,


string mainTelNo,


string mainFaxNo)





{


try


{


SqlParameter[] parameters = DA.SqlHelperParameterCache.GetSpParameterSet(this.ConnectionString,"UpdateCustomer");


parameters[0].Value = customerId;


parameters[1].Value = customerName;


parameters[2].Value = address1;


parameters[3].Value = address2;


parameters[4].Value = town;


parameters[5].Value = county;


parameters[6].Value = postcode;


parameters[7].Value = webSiteAddress;


parameters[8].Value = mainTelNo;


parameters[9].Value = mainFaxNo;


parameters[10].Direction = ParameterDirection.Output;





int RetVal = DA.SqlHelper.ExecuteNonQuery(this.Connection,"UpdateCustomer",parameters);





if (RetVal > 0)


{


int Key = Convert.ToInt32(parameters[10].Value.ToString());


}





}


catch (Exception ex)


{


throw new Exception(ex.Message.ToString(), ex);


}





}








And here's the SQL Server 2000 Stored Procedure:








CREATE PROCEDURE UpdateCustomer





@CustomerId int,


@CustomerName varchar(100),


@Address1 varchar(50),


@Address2 varchar(50),


@Town varchar(30),


@County varchar(30),


@PostCode varchar(10),


@WebSite varchar(50),


@MainTelNo varchar(15),


@MainFaxNo varchar(15),


@ReturnValue int OUTPUT





AS





IF @CustomerId = 0


BEGIN


INSERT INTO Customer


(CustomerName, Address1, Address2, Town, County, Postcode, WebSite, MainTelNo, MainFaxNo)


VALUES(@CustomerName, @Address1, @Address2, @Town, @County, @Postcode, @WebSite, @MainTelNo, @MainFaxNo)





IF @@ERROR = 0


BEGIN


SELECT @ReturnValue = @@IDENTITY


END


ELSE


BEGIN


SELECT @ReturnValue = -1


END





END


ELSE


BEGIN


UPDATE Customer


SETCustomerName = @CustomerName,


Address1 = @Address1,


Address2 = @Address2,


Town = @Town,


County = @County,


Postcode = @Postcode,


WebSite = @WebSite,


MainTelNo = @MainTelNo,


MainFaxNo = @MainFaxNo


WHERECustomerId = @CustomerId





IF @@ERROR = 0


BEGIN


SELECT @ReturnValue = @CustomerId


END


ELSE


BEGIN


SELECT @ReturnValue = -1


END


END











Any help would be appreciated as it's starting to drive me mad now!!