Stored procedure C#

Question

I am using a stored procedure to insert a record into a table. i am passing an output paramater to get the identity value of the row inserted. The stored procedure is working fine and i am able to see the out put value. BUT WHEN I AM USING C# CODE FOR RETRIEVING THE VALUE, THE VALUE IS OF THE OUTPUT PARAMETER IS BEING SET TO DBNULL.VALUE. could you please help me out. omkar

S_Kiryazov · Answer

If you are sure that you have set the Direction and DbType appropriately then show some code.

plot · Answer

Provising the @@IDENTIFY or your sp is working ok make sure the parameter objects that are wrapped in your COmmand have a Direction of output and that they are the correct DBType. Chris