How do i give output direction for the output paramter in C#? (ADO .NET)

Question

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", <db type>, <size>, <column name>);

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