How get an sproc OUTPUT parameter?

[mscertified]

I hope this is the right forum. I'm a complete beginner at .NET and C#.
This is some code in a web service that calls an sproc that has an OUTPUT
parameter. Can anyone tell me how to code getting the output parameter? The
commented out code is a failed attempt. Thanks.

try
{
Database db = DatabaseFactory.CreateDatabase("SqlServices");
System.Data.Common.DbCommand dbCommand =
db.GetStoredProcCommand("MonthlyPaymentList");

db.AddInParameter(dbCommand, "AsOfDate", DbType.DateTime,
AsOfDate);
db.AddOutParameter(dbCommand, "ErrorId", DbType.Int64, 16);

DataSet ds = db.ExecuteDataSet(dbCommand);

//int errorId = (int)db.GetParameterValue(dbCommand,
"ErrorId");
//if (errorId != 0)
//{
// return null;
//}

return ds;
}

 

[Mark Stevens]

db.AddOutParameter(dbCommand, "ErrorId", DbType.Int64, 16);

DataSet ds = db.ExecuteDataSet(dbCommand);

//int errorId = (int)db.GetParameterValue(dbCommand,
"ErrorId");

Just a thought but doesn't int map to Int32 and not Int64?

Regards,
Mark
--
|\ _,,,---,,_ A picture used to be worth a
ZZZzzz /,`.-'`' -. ;-;;, thousand words - then along
|,4- ) )-,_. ,\ ( `'-' came television!
'---''(_/--' `-'\_)

Mark Stevens (mark at thepcsite fullstop co fullstop uk)

This message is provided "as is".