Loading

Stored procedure C#

omkar

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

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

S_Kiryazov22y ago
If you are sure that you have set the Direction and DbType appropriately then show some code.
plot22y ago
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