read an output parameter from a stored procedure by its name?

O

Ola Fjelddahl

hi.

I cannot retrieve an output parameter from a stored procedure by name. Is
this correct?

Works not:
[ sParamValue = mycmd.Parameters["@ID"].Value.ToString(); ]

Works fine:
[ sParamValue = mycmd.Parameters[0].Value.ToString(); ]

TIA

/OF
 
O

Ola Fjelddahl

hi.

Sorry. Forget my question. There was a stray space in a variable that
fooled me for two days. The code below works alright.
I cannot retrieve an output parameter from a stored procedure by name. Is
this correct?
Works not:
[ sParamValue = mycmd.Parameters["@ID"].Value.ToString(); ]
Works fine:
[ sParamValue = mycmd.Parameters[0].Value.ToString(); ]
Click to expand...

/OF
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

No output parameter....... 1
Command Execute 2
Retrieving output params from stored procedure? 1
SQLHelper STored Procedure Output Parameter 6
Calling a stored procedure with a output parameter 1
output parameter syntax 4
Help with Microsoft.ApplicationBlocks.Data SPOC Sample 1
how to select row from datagridview when column have cells is empty 0

Top