Hi Haansi,

Haansi

It is when I need to catch 2 output parameters should I do like:

It won't execute your procedure when you call these lines.

db.GetParameterValue(dbCommand, "@LeaveID");

db.GetParameterValue(dbCommand, "@UserId");

Actually, it is called when you call db.ExecuteNonQuery(dbCommand); After this, all the output parameters are retrieved from the your procedure.  You can see the steps from this link.   http://msdn.microsoft.com/en-us/library/system.data.common.dbcommand.aspx

Best regards,

Jonathan