Thanks DarrellNorton,

Please guide me one more thing.

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

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

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

also will it call stored procedure two times ? or for gettign all output paramters it will just call sp once ?