Hi,
i need to retreive some data from database. I have command object "cmd". it has a paramter (output paramter) that will hold a return data from the database.
cmd.paramters.add("@p",
but we need ot specify the direction of this paramter. In VB .NET there is property called "Item" in the "paramters" collection. The from the "Item" we can call teh direction property. But in C# it doesnt provide those properties form SQLCOmmand object.
How do we give the direction for the output parameter from C# code?
cheers
Rajendra DeopuraPosted Mar 26, 2009, 8:02 AM
If you are supplying parameters using SqlParameter Class. Then, in order to retrieve the value of output parameters you can use the Direction property of SqlParameter class.
Example ;
objParameter.Direction=ParameterDirection.Output ;
For any other queries, contact me on :
[email protected]
Thanks